CREATE VIEW dbo.PLAS_RAPOR_AYLIK_SEHIR_TOPLAM
AS
SELECT   CLF.MONTH_, SLS.LOGICALREF, ISNULL(SLS.DEFINITION_, 'SIRKET') AS PLS, CLC.CITY, SUM(CLF.TRNET) AS TUTAR
FROM         dbo.LG_011_08_CLFLINE AS CLF LEFT OUTER JOIN
                         dbo.LG_SLSMAN AS SLS ON CLF.SALESMANREF = SLS.LOGICALREF LEFT OUTER JOIN
                         dbo.LG_011_CLCARD AS CLC ON CLC.LOGICALREF = CLF.CLIENTREF
WHERE     (CLF.TRCODE = 38) AND (CLF.CANCELLED = 0)
GROUP BY CLF.MONTH_, SLS.DEFINITION_, SLS.LOGICALREF, CLC.CITY