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