select 库存表.品名,库存表.数量,
(select sum(数量) from 入库表 where 品名=库存表.品名) as 累计入库数量,
(select sum(数量) from 出库表 where 品名=库存表.品名) as 累计出库数量,
from 库存表
(select sum(数量) from 入库表 where 品名=库存表.品名) as 累计入库数量,
(select sum(数量) from 出库表 where 品名=库存表.品名) as 累计出库数量,
from 库存表
from 库存表 a inner join 入库表 b on a.品名=b.品名 inner join 出库表 c on a.品名=c.品名 group by a.品名
(select sum(数量) from 入库表 where 品名=库存表.品名) as 累计入库数量,
(select sum(数量) from 出库表 where 品名=库存表.品名) as 累计出库数量,
from 库存表
IsNull(sum(b.数量),0) as 累计入库数量,
IsNull(sum(c.数量),0) as 累计出库数量,
from 库存表 a
Left Join 入库表 b on a.品名 = b.品名
Left join 出库表 c on a.品名 = c.品名
group by a.品名