Merhaba,
SELECT LG_813_CLCARD.SPECODE, LG_813_CLCARD.CODE, LG_813_CLCARD.DISTRICT, LG_813_CLCARD.DEFINITION_, LG_813_01_PAYTRANS.PROCDATE, LG_813_01_PAYTRANS.DATE_, Sum(LG_813_01_CLRNUMS.RISKTOTAL) AS 'Toplam/RISKTOTAL', LG_813_01_PAYTRANS.TOTAL, LG_813_01_PAYTRANS.CANCELLED
FROM UNITY.dbo.LG_813_01_CLRNUMS LG_813_01_CLRNUMS, UNITY.dbo.LG_813_01_PAYTRANS LG_813_01_PAYTRANS, UNITY.dbo.LG_813_CLCARD LG_813_CLCARD
WHERE LG_813_CLCARD.LOGICALREF = LG_813_01_CLRNUMS.CLCARDREF AND LG_813_CLCARD.LOGICALREF = LG_813_01_PAYTRANS.CARDREF AND ((LG_813_01_PAYTRANS.CLOSINGRATE=0) AND (LG_813_01_PAYTRANS.TRCODE=8))
GROUP BY LG_813_CLCARD.SPECODE, LG_813_CLCARD.CODE, LG_813_CLCARD.DISTRICT, LG_813_CLCARD.DEFINITION_, LG_813_01_PAYTRANS.PROCDATE, LG_813_01_PAYTRANS.DATE_, LG_813_01_PAYTRANS.TOTAL, LG_813_01_PAYTRANS.CANCELLED
HAVING (LG_813_01_PAYTRANS.CANCELLED=0)
ORDER BY LG_813_CLCARD.DEFINITION_, LG_813_01_PAYTRANS.DATE_
bu şekilde denermisiniz