set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[STPListStock-DetailRemain] AS SELECT VWCompleteGood.GoodSyscode, VWCompleteGood.Title, VWCompleteGood.Code, VWCompleteGood.BarCode, VWCompleteGood.Type, VWCompleteGood.FstUnit, VWCompleteGood.SecUnit, VWCompleteGood.UnitRate, VWCompleteGood.OrderPoint, VWCompleteGood.SalePrice1, VWCompleteGood.SalePrice2, VWCompleteGood.SalePrice3, VWCompleteGood.SalePrice4, VWCompleteGood.SalePrice5, VWCompleteGood.VisitorPer, VWCompleteGood.Comment, VWCompleteGood.DiscontPer, VWCompleteGood.UserPrice, VWCompleteGood.GroupName1, VWCompleteGood.GroupName2, VWCompleteGood.Term, VWCompleteGood.Weight, VWGoodDetailRemain.Remain, WareHouseTbl.WareHouseName, GoodColorTbl.ColorName, GoodSizeTbl.SizeName, VWGoodDetailRemain.SerialNo,TypeId, GroupId1, GroupId2 FROM VWCompleteGood LEFT OUTER JOIN GoodSizeTbl RIGHT OUTER JOIN VWGoodDetailRemain ON GoodSizeTbl.SysCode = VWGoodDetailRemain.Size LEFT OUTER JOIN GoodColorTbl ON VWGoodDetailRemain.Color = GoodColorTbl.SysCode LEFT OUTER JOIN WareHouseTbl ON VWGoodDetailRemain.WareHouse = WareHouseTbl.SysCode ON VWCompleteGood.GoodSyscode = VWGoodDetailRemain.GoodSysCode