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