数据库 用一条sql语句得到两个表中数据的统计

Question

用一条sql语句得出A和B的剩余数量

Answer 1

select a.name,a.buy-b.sell as left
from
(
select name,sum(buy) as buy
from tableA
where name in ('A','B')
group by name
) a
left outer join
(
select name,sum(sell) as sell

from tableB

where name in ('A','B')
group by name
) b
on a.name = b.name本回答被提问者和网友采纳