CREATE VIEW dbo.URETICI_KOD_LISTESI
AS
SELECT        ITM.CODE, PRC.PRODUCERCODE, CMP.DEFINITION_, PRC.REF
FROM            dbo.PRODUCERCODES AS PRC LEFT OUTER JOIN
                         dbo.ITEMS AS ITM ON ITM.REF = PRC.STOCKREF LEFT OUTER JOIN
                         dbo.COMPANIES AS CMP ON CMP.REF = PRC.CLIENTREF