CREATE VIEW [dbo].[V_FaturaTevkifat]
AS
SELECT        dbo.FaturaTevkifat.NoID, dbo.FaturaTevkifat.sGuid, dbo.Tevkifat.Kodu, dbo.Tevkifat.Aciklama, dbo.FaturaTevkifat.Oran, dbo.FaturaTevkifat.Baz, dbo.FaturaTevkifat.
Tutar
FROM            dbo.StokTevkifat LEFT OUTER JOIN
                         dbo.Tevkifat ON dbo.StokTevkifat.SatisTevkifatID = dbo.Tevkifat.ID RIGHT OUTER JOIN
                         dbo.STOKHAR ON dbo.StokTevkifat.StokKodu = dbo.STOKHAR.StokKodu RIGHT OUTER JOIN
                         dbo.FaturaTevkifat ON dbo.STOKHAR.sGuid = dbo.FaturaTevkifat.sGuid

CREATE VIEW V_StokTevkifat  
AS
SELECT        dbo.StokTevkifat.NoID, dbo.StokTevkifat.StokKodu, dbo.StokTevkifat.SatisTevkifatID, dbo.Tevkifat.Kodu, dbo.Tevkifat.Aciklama, dbo.Tevkifat.Oran, dbo.Tevkifat.Baz
FROM            dbo.Tevkifat RIGHT OUTER JOIN
                         dbo.StokTevkifat ON dbo.Tevkifat.ID = dbo.StokTevkifat.SatisTevkifatID