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