CREATE VIEW dbo.StokHareketleriTumu
AS
SELECT        STOCKREF, DATE_, ONHAND
FROM            (SELECT        STOCKREF, DATE_, ONHAND
                          FROM            dbo.StokHareketleriTumYillar
                          UNION ALL
                          SELECT        STOCKREF, DATE_, ONHAND
                          FROM            dbo.LV_011_07_STINVTOT
                          WHERE        (INVENNO = 0) AND (TRANSFERRED = 0)
                          UNION ALL
                          SELECT        STOCKREF, DATE_, ONHAND
                          FROM            dbo.LV_011_08_STINVTOT
                          WHERE        (INVENNO = 0) AND (TRANSFERRED = 0)) AS QQ