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