SELECT
CARI.LOGICALREF [LREF],
CARI.CODE,
CARI.DEFINITION_ ,
'BAKIYE'=CASE
WHEN ISNULL(BAKIYE.BAKIYE,0)<0 THEN CONVERT(NVARCHAR,format(ABS(ISNULL(BAKIYE.BAKIYE,0)),'n2','tr-TR'))+' (A)'
WHEN ISNULL(BAKIYE.BAKIYE,0)>0 THEN CONVERT(NVARCHAR,format(ABS(ISNULL(BAKIYE.BAKIYE,0)),'n2','tr-TR'))+' (B)'
END
FROM LG_XXX_CLCARD CARI
LEFT JOIN (SELECT SUM(DEBIT-CREDIT) AS BAKIYE,CARDREF AS CARDREF FROM LV_XXX_XX_GNTOTCL WHERE TOTTYP=1 GROUP BY CARDREF ) BAKIYE ON CARI.LOGICALREF =BAKIYE.CARDREF
WHERE CARI.CARDTYPE<>22 AND CARI.ACTIVE=0