请问如何通过sql语句这三个不同结构形式的表的数据做成进销存表格的形式呢？

bao123

请问如何通过sql语句将购入、上月结存、本月领用这三个表的数据做成进销存表格的形式呢？

sowincn

Sqla ="select 品名,sum(数量),sum(金额) from [购入$] group by 品名"
Sqlb ="select 品名,sum(数量),sum(金额) from [本月领用$] group by 品名"

sqlc="select A.品名,A.规格,A.单位,A.上月结存数量,A.单价,A.金额,B.数量        ,B.金额
from [上月结存$] as A left join (" & Sqla & ") AS B ON A.品名=B.品名"

sqld= "select A.*,B.数量,B.金额,(A.上月结存数量+A.数量-B.数量) AS 结存数量,(A.上月结存金额+A.金额-B.金额)/(A.上月结存数量+A.数量-B.数量) AS 结存单价,(A.上月结存金额+A.金额-B.金额) AS 结存金额 from (" & sqlc & ") AS A left join (" & sqlb & ") as B  ON A.品名=B.品名"