--try
select A.*,剩餘=B.qty-isnull((select sum(qty) from T2 where inno=A.inno and item=A.item and outno<=A.outno ),0)
from T2 A inner join T1 B on A.item=B.item
select A.*,剩餘=B.qty-isnull((select sum(qty) from T2 where inno=A.inno and item=A.item and outno<=A.outno ),0)
from T2 A inner join T1 B on A.item=B.item
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货