CREATE VIEW dbo.KARGO_BARKOD_LISTESI
AS
SELECT        KRG.CARIREF, KRG.ENTEGRENO, KRG.KOLI, KFS.IRSREF, KRF.BARKODNO, KRF.DESI, KFS.FATREF, KRG.REF
FROM            dbo.KARGOLAR AS KRG LEFT OUTER JOIN
                         dbo.KARGOLAR_BARKOD AS KRF ON KRF.KARGOREF = KRG.REF LEFT OUTER JOIN
                         dbo.KARGOLAR_FIS AS KFS ON KFS.KARGOREF = KRG.REF