set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO




ALTER PROCEDURE [dbo].[STPListStock-simpleRemain] 
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, VWCompleteGood.SerialNo, 
                      VWGoodSimpleRemain.Remain, VWGoodAvrageFee.AvgFee, VWGoodSimpleLastSummary.LastFee, VWGoodSimpleLastSummary.LastSeller, 
                      VWGoodSimpleLastSummary.LastDate, VWGoodSimpleLastSummary.LastFee * VWGoodSimpleRemain.Remain AS TotalAmount,TypeId, GroupId1, GroupId2
FROM         VWCompleteGood LEFT OUTER JOIN
                      VWGoodSimpleLastSummary ON VWCompleteGood.GoodSyscode = VWGoodSimpleLastSummary.GoodSysCode LEFT OUTER JOIN
                      VWGoodAvrageFee ON VWCompleteGood.GoodSyscode = VWGoodAvrageFee.GoodSysCode LEFT OUTER JOIN
                      VWGoodSimpleRemain ON VWCompleteGood.GoodSyscode = VWGoodSimpleRemain.GoodSysCode