Question

sql查两个表相减的结果

有两个表
表一 AA
种类T 库存总量S
A 997
B 1234
表二 BB
种类T 出库数量S
A 105
A 213
B 116
B 211
B 303
用一条SQL语句求出A,B各剩下多少?

Answer 1

select T, sum(s)

from (

select 种类T as T, 库存总量S as s from AA
UNION ALL select 种类T as T, 出库数量S*(-1) as s FROM BB) tabT
group by T