CREATE VIEW dbo.PLAS_SEHIR_SIRALI_IADE AS
SELECT        LOGICALREF, ROW_NUMBER() OVER (ORDER BY LOGICALREF) AS SIRA, CM.MANG AS MANG, CM.PLAS AS PLAS, QQ.CITY
FROM            (SELECT DISTINCT LOGICALREF, CITY
                          FROM            dbo.PLAS_RAPOR_AYLIK_SEHIR_TOPLAM
                          WHERE        LOGICALREF IS NOT NULL) QQ LEFT OUTER JOIN
                         CITY_MANG AS CM ON CM.SALESMANREF = QQ.LOGICALREF
						 WHERE CM.MANG IS NOT NULL