Bu kdr da basit bir hata nasıl gözden kaçar , işte hep kopyala yapıştır , Sanırım Excel forum sitesinede fazla sormak istemedin
ikinci FROM ' u kaldır , bu kadar.
DECLARE @İlkTar VARCHAR(10) set @İlkTar='01-07-2019'
DECLARE @SonTar VARCHAR(10) set @SonTar='07-07-2019'
SELECT
C.CODE AS KOD,
C.DEFINITION_ AS ISIM,
ISNULL(SUM(T.DEBIT),0) AS BORC_TOPLAMI,
ISNULL(SUM(T.CREDIT),0) AS ALACAK_TOPLAMI,
ISNULL(SUM(T.DEBIT-T.CREDIT),0) AS KALAN_BAKIYE
FROM dbo.LG_019_CLCARD C LEFT JOIN
dbo.LG_019_01_CLTOTFIL T
ON C.LOGICALREF=T.CARDREF AND T.TOTTYP=1
WHERE
C.CARDTYPE <>22
AND C.ACTIVE=0
GROUP BY
C.CODE,C.DEFINITION_
ORDER BY C.CODE