7,714
社区成员
发帖
与我相关
我的任务
分享
create table tin(pid varchar(5),ins int)
create table tout(pid varchar(5),outs int)
insert into tin values('产品1',10)
insert into tin values('产品2',20)
insert into tin values('产品3',10)
insert into tin values('产品1',30)
insert into tin values('产品2',50)
insert into tout values('产品1',5)
insert into tout values('产品2',5)
insert into tout values('产品2',15)
insert into tout values('产品1',25)
select * from tin
select * from tout
select tti.pid as 产品名称,
tti.allins as 总进货量,
tto.allouts as 总销售量,
tti.allins-tto.allouts as 库存量
from
(select pid,sum(outs) as allouts from tout group by pid) as tto full join
(select pid,sum(ins) as allins from tin group by pid) as tti on tti.pid=tto.pid
drop table tin
drop table tout