SELECT recibos.ID_CLAVE, recibos.ID_INQUILI, recibos.ID_PROPIED,
recibos.YEAR, recibos.MONTH, recibos.PAGADO,
recibos.FULL_NAME, recibos.FULL_DIR, recibos.LOCALIDAD, recibos.PROVINCIA,
GAST_CANTIDAD,GAST_IVA, GAST_RETENCION, GAST_TOTAL, ING_CANTIDAD,
ING_IVA, ING_RETENCION, ING_TOTAL
FROM recibos
LEFT JOIN (
Select ingresos.ID_RECIBO,
SUM(ingresos.CANTIDAD) AS ING_CANTIDAD,
SUM(ingresos.IVA) AS ING_IVA,
SUM(ingresos.RETENCION) AS ING_RETENCION,
SUM(ingresos.TOTAL) AS ING_TOTAL,
From Ingresos As Ingresos
Inner Join recibos As Recibos
On recibos.ID_INQUILI = "0000001" AND
recibos.ID_PROPIED = "1000000" And
recibos.ID_CLAVE=ingresos.ID_RECIBO
Group By ingresos.ID_RECIBO
) As DatIngresos
On recibos.ID_CLAVE=DatIngresos.ID_RECIBO
LEFT JOIN (
Select gastos.ID_RECIBO,
SUM(gastos.CANTIDAD) AS GAST_CANTIDAD,
SUM(gastos.IVA) AS GAST_IVA,
SUM(gastos.RETENCION) AS GAST_RETENCION,
SUM(gastos.TOTAL) AS GAST_TOTAL
From gastos As gastos
Inner Join recibos As Recibos
On recibos.ID_INQUILI = "0000001" AND
recibos.ID_PROPIED = "1000000" And
recibos.ID_CLAVE = gastos.ID_RECIBO
Group By gastos.ID_RECIBO
) As Datgastos
On recibos.ID_CLAVE = Datgastos.ID_RECIBO
Where recibos.ID_INQUILI = "0000001" AND
recibos.ID_PROPIED = "1000000"