Thank you for your reply, but instead of a textual description of a test or calculation, you can propose a solution how to make equality comparison.Sample query follows.
SELECT
CONVERT(VARCHAR,PT.DATE_,104)'Vade Tarihi',
CC.CODE CARI_KOD,
CC.DEFINITION_ ÜNVAN,
CASE(PT.MODULENR)
WHEN 3 THEN'SIPARIS'
WHEN 4 THEN'FATURA'
WHEN 5 THEN'CARI FIS'
WHEN 6 THEN'Çek - Senet'
WHEN 7 THEN'BANKA'
WHEN 10 THEN'KASA'
ELSE 'DIGER'
END 'TÜR',
--C.MODULENR, --Bu satir Pasif Yapilabilir.
CASE
WHEN (PT.MODULENR=4) AND (PT.TRCODE=2) THEN 'PER.SATIS.IADE.FTR'
WHEN (PT.MODULENR=5) AND (PT.TRCODE=3) THEN 'BORÇ DEKONTU'
WHEN (PT.MODULENR=7) AND (PT.TRCODE=3) THEN 'Gelen Havale'
WHEN (PT.MODULENR=3) AND (PT.TRCODE=1) THEN 'SATIS SIPARISI'
END 'Fis Türü',
PT.DOCODE [Belge No],
PT.MODULENR MODÜL,
PT.TRCODE 'TRCODE',
CASE
WHEN PT.SIGN ='1' THEN 'ALACAK'
WHEN PT.SIGN ='0' THEN 'BORÇ'
END DURUM,
CASE
WHEN MONTH(PT.DISCDUEDATE)= '1' THEN 'Ocak'
WHEN MONTH(PT.DISCDUEDATE)= '2' THEN 'Subat'
WHEN MONTH(PT.DISCDUEDATE)= '3' THEN 'Mart'
WHEN MONTH(PT.DISCDUEDATE)= '4' THEN 'Nisan'
WHEN MONTH(PT.DISCDUEDATE)= '5' THEN 'Mayis'
WHEN MONTH(PT.DISCDUEDATE)= '6' THEN 'Haziran'
WHEN MONTH(PT.DISCDUEDATE)= '7' THEN 'Temmuz'
WHEN MONTH(PT.DISCDUEDATE)= '8' THEN 'Agustos'
WHEN MONTH(PT.DISCDUEDATE)= '9' THEN 'Eylül'
WHEN MONTH(PT.DISCDUEDATE)= '10' THEN 'Ekim'
WHEN MONTH(PT.DISCDUEDATE)= '11' THEN 'Kasim'
WHEN MONTH(PT.DISCDUEDATE)= '12' THEN 'Aralik'
END AY,
PT.TRCODE FIS_TÜRÜ,
SUM(PT.TOTAL) TUTAR,
PT.PAID AS KAPANAN,
SUM(PT.TOTAL)-PT.PAID AS FARK,
CASE
WHEN (PT.MODULENR<>3) AND (PT.TRCODE<>1) AND (SUM(PT.TOTAL)-PT.PAID<>0) THEN 'AÇIK ISLEM KONTROL ET'
WHEN (PT.MODULENR<>3) AND (PT.TRCODE<>1) AND (SUM(PT.TOTAL)-PT.PAID=0) THEN 'MANUEL KAPATILMIS'
WHEN (PT.MODULENR=3) AND (PT.TRCODE=1) AND (SUM(PT.TOTAL)-PT.PAID=0) THEN 'FATURA KESILMIS'
WHEN (PT.MODULENR=3) AND (PT.TRCODE=1) AND (SUM(PT.TOTAL)-PT.PAID>0) THEN 'FATURA KES'
END FATURA_DURUMU,
PT.FICHEREF AS [Fis Referansi]
FROM LG_011_01_PAYTRANS AS PT
INNER JOIN LG_011_CLCARD AS CC
ON PT.CARDREF = CC.LOGICALREF
WHERE CC.DEFINITION_ LIKE 'XXXXXXX' AND [FATURA_DURUMU] ='FATURA KES' -- I think this line second and got to do a modification and syntax.
GROUP BY
CC.CODE,
PT.TRCODE,
PT.DISCDUEDATE,
PT.TOTAL,
CC.DEFINITION_,
PT.MODULENR,
PT.SIGN,
PT.DATE_,
PT.DOCODE,
PT.PAID,
PT.FICHEREF
ORDER BY PT.DATE_
Print results :
Msg 207, Level 16, State 1, Line 61
Invalid column name 'FATURA_DURUMU'.
Thanks,