CREATE VIEW dbo.BARKOD
AS
SELECT        TOP (100) PERCENT dbo.LG_011_ITEMS.CODE AS KODU, dbo.LG_011_ITEMS.NAME AS ADI, dbo.LG_011_ITEMS.LOGICALREF, dbo.LG_011_08_STLINE.AMOUNT, dbo.LG_011_08_STFICHE.FICHENO, 
                         dbo.LG_011_08_STLINE.AMOUNT AS ADETT
FROM            dbo.LG_011_ITEMS INNER JOIN
                         dbo.LG_011_08_STLINE ON dbo.LG_011_ITEMS.LOGICALREF = dbo.LG_011_08_STLINE.STOCKREF INNER JOIN
                         dbo.LG_011_08_STFICHE ON dbo.LG_011_08_STLINE.STFICHEREF = dbo.LG_011_08_STFICHE.LOGICALREF
ORDER BY ADI