Consulta rebelde

[[poliburro]]

Código SQL [-]
 
       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"