CREATE VIEW dbo.CARI_TOPLAMLAR_DETAY
AS
SELECT CC.CODE,CC.DEFINITION_, TC.TOPLAMLAR, TC.[ISLEM ADEDI]
FROM LG_011_CLCARD AS CC LEFT OUTER JOIN
dbo.TOPLAMLARI_CARI AS TC ON CC.LOGICALREF=TC.CLIENTREF
WHERE ACTIVE=0