SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER VIEW [dbo].[VWCompleteGood] AS SELECT dbo.StockTbl.GoodSyscode, dbo.StockTbl.Title, dbo.StockTbl.Code, dbo.StockTbl.BarCode, dbo.infoGoodTypeTbl.Title AS Type, dbo.StockTbl.FstUnit, dbo.StockTbl.SecUnit, dbo.StockTbl.UnitRate, dbo.StockTbl.OrderPoint, dbo.StockTbl.SalePrice1, dbo.StockTbl.SalePrice2, dbo.StockTbl.SalePrice3, dbo.StockTbl.SalePrice4, dbo.StockTbl.SalePrice5, dbo.StockTbl.VisitorPer, dbo.StockTbl.Comment, dbo.StockTbl.DiscontPer, dbo.StockTbl.UserPrice, dbo.stockGroup1Tbl.GroupName AS GroupName1, dbo.stockGroup2Tbl.GroupName AS GroupName2, dbo.StockTbl.Term, dbo.StockTbl.Weight, dbo.StockTbl.SerialNo, dbo.StockTbl.Type AS TypeId, dbo.stockGroup1Tbl.GroupId AS GroupId1, dbo.stockGroup2Tbl.GroupId AS GroupId2 FROM dbo.stockGroup2Tbl RIGHT OUTER JOIN dbo.StockTbl ON dbo.stockGroup2Tbl.GroupId = dbo.StockTbl.GroupID2 LEFT OUTER JOIN dbo.stockGroup1Tbl ON dbo.StockTbl.GroupID1 = dbo.stockGroup1Tbl.GroupId LEFT OUTER JOIN dbo.infoGoodTypeTbl ON dbo.StockTbl.Type = dbo.infoGoodTypeTbl.Code GO SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER OFF GO