CREATE VIEW [CARI_TOPLAMLAR] AS
SELECT CR.SM, SUM(CF.TRNET) AS TOPLAM
FROM     dbo.LG_011_06_CLFLINE AS CF LEFT OUTER JOIN
                  dbo.XYZ AS CR ON CF.CLIENTREF = CR.LOGICALREF
WHERE  (CF.TRCODE = 38) AND (CF.CANCELLED = 0)
GROUP BY CR.SM