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