Insert Into stock(bID, stockQty)
select x.bID, 进货数量 - 销售数量
from (select bID, sum(purQty) as 进货数量 from purchInfo group by bID) x inner join
(select bID, sum(saleQty) as 销售数量 from sale group by bID) y on x.bID = y.bID
select x.bID, 进货数量 - 销售数量
from (select bID, sum(purQty) as 进货数量 from purchInfo group by bID) x inner join
(select bID, sum(saleQty) as 销售数量 from sale group by bID) y on x.bID = y.bID
select bid,sum(purqyt) from (
select bid,purqyt from purchinfo
union all
select bid,-saleQty from purchinfo) tem group by bid
insert stock (bID,stockQty)
select bid,sum(purqyt) from (
select bid,purqyt from purchinfo
union all
select bid,-saleQty from purchinfo) tem group by bid
select a.bID,sum(a.purQty)-isnull((select sum(b.saleQty) from sale b where a.bID=b.bID),0) from purchInfo group by bID
values(stock.bID=(select distinct purchInfo.bID from purchInfo),
stock.stockQty=(select purchInfo.purQty from purchInfo group by purchInfo.bID)-(select sale.saleQty from sale group by sale.bID))