CREATE VIEW dbo.TOPLAM_SATISLAR_07
AS
SELECT   SUM(ST.AMOUNT) AS TOPLAM, IT.LOGICALREF
FROM         dbo.LG_011_08_STLINE AS ST LEFT OUTER JOIN
                         dbo.LG_011_ITEMS AS IT ON ST.STOCKREF = IT.LOGICALREF
WHERE     (ST.TRCODE = 8) AND (ST.LINETYPE = 0) AND (ST.CANCELLED = 0)
GROUP BY IT.LOGICALREF