主题：[求助]

以下内容为程序代码:

1 select a.*,
2 (select sum(基本单位数量) f-rom{即时库存} b
3 where a.[芯片规格]=b.[规格型号]) as [芯片库存]
4 f-rom (select distinct [芯片规格],[客户简称],[客户料号],
5 sum([产品预测数量（参考）]) as [产品预测数量（参考）],
6 sum([产品毛需求]) as [产品毛需求],
7 sum([产品库存量]) as [产品库存量],
8 sum([产品在制量]) as [产品在制量] f-rom {加芯片前MRP汇总表}
9 Group by [芯片规格],[客户简称],[客户料号]) a