SELECT CR.DEFINITION_,
ISNULL(SUM(CASE WHEN ST.TRCODE=8 THEN ST.VATMATRAH END),0)-ISNULL(SUM(CASE WHEN ST.TRCODE=3 THEN ST.VATMATRAH END),0)
FROM LG_005_CLCARD CR INNER JOIN LG_005_01_STLINE ST ON CR.LOGICALREF=ST.CLIENTREF
AND CR.CODE BETWEEN '1000' AND '1250'
AND ST.DATE_ BETWEEN '01/01/2009' AND '31/12/2009'
GROUP BY CR.DEFINITION_
UNION ALL
SELECT CR.DEFINITION_,
ISNULL(SUM(CASE WHEN CLF.TRCODE=4 THEN CLF.AMOUNT END),0)+ISNULL(SUM(CASE WHEN CLF.TRCODE=5 THEN CLF.AMOUNT END),0)
FROM LG_005_CLCARD CR INNER JOIN LG_005_01_CLFLINE CLF ON CR.LOGICALREF=CLF.CLIENTREF
AND CLF.DATE_ BETWEEN '01/01/2009' AND '31/12/2009'
AND CR.CODE BETWEEN '1000' AND '1250'
GROUP BY CR.DEFINITION_
BU SORGUYU TEK SORGU HALİNE NASIL GETİREBİLİRİM UNION ALL KALDIRIP
