CREATE VIEW dbo.SIRALI_CEK_LISTESI
AS
SELECT   CC.CODE, OW.LOGICALREF, ROW_NUMBER() OVER (ORDER BY CC.CODE) AS SIRA
FROM         LG_011_08_CSCARD AS OW LEFT JOIN
                         LG_011_CLCARD AS CC ON OW.OWING = CC.DEFINITION_
WHERE     CC.CODE IS NOT NULL