Incearca

SELECT dbo.PARTENERI.NUME, dbo.ANTET_FACTURI.ID AS aidi, dbo.ANTET_FACTURI.NUMECLIENT, dbo.ANTET_FACTURI.NRDOC, dbo.ANTET_FACTURI.DATA, dbo.ANTET_FACTURI.MONEDA, dbo.ANTET_FACTURI.SERIECARD, Q1.S AS SUMA_DE_PLATA, Q2.S AS SUMA_PLATITA, Q1.S - ISNULL(Q2.S,0) AS REST FROM dbo.ANTET_FACTURI INNER JOIN dbo.PARTENERI ON dbo.ANTET_FACTURI.ID_PARTENER = dbo.PARTENERI.ID INNER JOIN ( SELECT ID_FACTURA, SUM(PRET_UNITAR) AS S FROM dbo.DETAIL_FACTURI GROUP BY ID_FACTURA ) AS Q1 ON dbo.ANTET_FACTURI.ID = Q1.ID_FACTURA LEFT OUTER JOIN ( SELECT ID_ANTET_FACTURA, SUM(VALOARE) AS S FROM dbo.CHITANTECL GROUP BY ID_ANTET_FACTURA ) AS Q2 ON dbo.ANTET_FACTURI.ID = Q2.ID_ANTET_FACTURA WHERE Q1.S - ( Q1.S - ISNULL(Q2.S,0) )  >   0 --adica ISNULL(Q2.S,0) > 0