求如何解决这一查询问题?

fnsmydyang

以上附件是网上搜到的一联合查询与选择查询求出进销存实例,我想用SQL语句一次性得到进销存,请问如何修改?
联合查询查询名:queTest)
select 零件编号, 上期结存量, 0 as 进货量, 0 as 出货量 from tbl上期结存
union all select 零件编号, 0 as 上期结存量, 进货量, 0 as 出货量 from tbl本期进货
UNION ALL select 零件编号, 0 as 上期结存量, 0 as 进货量, 出货量 from tbl本期出货
选择查询:
SELECT queTest.零件编号, Sum(queTest.上期结存量) AS 上期结存, Sum(queTest.进货量) AS 本期进货, Sum(queTest.出货量) AS 本期出货, [上期结存]+[本期进货]-[本期出货] AS 本期库存
FROM queTest
GROUP BY queTest.零件编号
求教各位老师们,先行谢谢了!

Henry D. Sy

SELECT A.零件编号, Sum(A.上期结存量) AS 上期结存, Sum(A.进货量) AS 本期进货, Sum(A.出货量) AS 本期出货, [上期结存]+[本期进货]-[本期出货] AS 本期库存
FROM [select 零件编号, 上期结存量, 0 as 进货量, 0 as 出货量 from tbl上期结存 union all select 零件编号, 0 as 上期结存量, 进货量, 0 as 出货量 from tbl本期进货 UNION ALL select 零件编号, 0 as 上期结存量, 0 as 进货量, 出货量 from tbl本期出货]. AS A
GROUP BY A.零件编号;

fnsmydyang

每次6D老师都能帮我解决问题,真的太谢谢您了.[:12]