Bueno no me funciono con Join asi q hice lo que deseaba con select anidados
Código HTML:
SELECT nombre AS Nombre, idConsorcio AS id, (
SELECT SUM( importe )
FROM ingreso
WHERE idConsorcio = id
) AS Ingresos, (
SELECT SUM( importe )
FROM egreso
WHERE idConsorcio = id
AND estado <> 'Por Pagar'
) AS Egresos, (
SELECT SUM( importe )
FROM egreso
WHERE idConsorcio = id
AND estado = 'Por Pagar'
) AS CuentaXPagar, (
SELECT Ingresos - Egresos
) AS Saldo, (
SELECT Saldo - CuentaXPagar
) AS Saldo2, (
SELECT SUM( monto )
FROM cuentaxcobrar
WHERE idConsorcio = id
) AS CuentaXCobrar
FROM `consorcio`