求助VB+access,将三张表的查询结果汇总成一张表,做仓库库存,入库,出库...答:仅仅是你上边数据的话 select a.名称,b.单价,a.库存数量,sum(b.总入库数量),sum(c.总出库数量)from 库存表 as a,(select 名称,单价,sum(入库数量) as 总入库数量 from 入库表 where 入库日期 between #2013-01-01# and #2013-04-11# group by 名称,单价) as b,(select 名称,sum(出库...