有两张表,第一张表AAA,有两个字段
商品名mc 商品总数s1
A 100
B 200
第二张表 BBB 也是两个字段
商品名mc 出库数量s1
A 10
A 20
A 30
B 30
B 20
写一条SQL语句,算出A,B的剩余数量
商品名mc 商品总数s1
A 100
B 200
第二张表 BBB 也是两个字段
商品名mc 出库数量s1
A 10
A 20
A 30
B 30
B 20
写一条SQL语句,算出A,B的剩余数量
from AAA,
(select 商品名mc,sum(出库数量s1) sums1 from BBB group by 商品名mc ) B
where AAA.商品名mc = B.商品名mc
(select mc,sum(s1) s1 from aaa group by mc) A,
(select mc,sum(s1) s1 from bbb group by mc) Bwhere A.mc=B.mc(+) group by A.mc
(select mc,sum(s1) s1 from aaa group by mc) A,
(select mc,sum(s1) s1 from bbb group by mc) Bwhere A.mc=B.mc(+) group by A.mc同意楼上
(select mc,sum(s1) as s1 from bbb group by mc) Bwhere A.mc=B.mc楼上的 看一下第一张表AAA,有两个字段
商品名mc 商品总数s1
A 100我同意一楼的
B 200
where a.mc = b.mc(+)
group by a.mc