CREATE VIEW dbo.[PLASIYERLER_IADE_SIRALI]
AS
SELECT        LOGICALREF, ROW_NUMBER() OVER (ORDER BY CM.PLAS) AS SIRA, CM.MANG AS MANG, 
CM.PLAS  AS PLAS
FROM            (SELECT DISTINCT LOGICALREF
                          FROM            dbo.PLAS_RAPOR_AYLIK_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