SELECT CL.CODE,CL.DEFINITION_,
ISNULL(SUM(CASE WHEN INV.TRCODE=8 THEN INV.TOTALDISCOUNTED END),0)-
ISNULL(SUM(CASE WHEN INV.TRCODE=3 THEN INV.TOTALDISCOUNTED END),0) 'KDVSİZ',
ISNULL(SUM(CASE WHEN INV.TRCODE=8 THEN INV.TOTALVAT END),0)-
ISNULL(SUM(CASE WHEN INV.TRCODE=3 THEN INV.TOTALVAT END),0) 'KDV',
ISNULL(SUM(CASE WHEN INV.TRCODE=8 THEN INV.NETTOTAL END),0)-
ISNULL(SUM(CASE WHEN INV.TRCODE=3 THEN INV.NETTOTAL END),0) 'KDVLİ'
FROM LG_005_01_INVOICE INV INNER JOIN
LG_005_CLCARD CL ON CL.LOGICALREF=INV.CLIENTREF
AND INV.DATE_ BETWEEN '01/01/2008' AND '31/01/2008'
GROUP BY CL.CODE,CL.DEFINITION_ ORDER BY CL.CODE
BU SORGUYU
SELECT CL.CODE,CL.DEFINITION_,
ISNULL(SUM(CASE WHEN INV.TRCODE=8
THEN INV.TOTALDISCOUNTED AND INV.TOTALVAT AND INV.NETTOTAL END),0)-
ISNULL(SUM(CASE WHEN INV.TRCODE=3
THEN INV.TOTALDISCOUNTED AND INV.TOTALVAT AND INV.NETTOTAL END),0)
FROM LG_005_01_INVOICE INV INNER JOIN
LG_005_CLCARD CL ON CL.LOGICALREF=INV.CLIENTREF
AND INV.DATE_ BETWEEN '01/01/2008' AND '31/01/2008'
GROUP BY CL.CODE,CL.DEFINITION_ ORDER BY CL.CODE
bu şekilde kısaltmaya çalıştım ama
Msg 156, Level 15, State 1, Line 3
Incorrect syntax near the keyword 'AND'.
bu hatayı verdi hatalı sorgunun düzeltme yolu varmı
yardımlarınız için şimdiden tşk. ederim