主题：[求助]关于SQL函数嵌套的问题

select a.*,基准数  from {SMT_DDPC} as a  left join (select 产品id, sum(基准数) as 基准数 from (Select w.产品id,(Selec t top 1 g.基准数 from {生产日报表视图} As g where g.产品ID = w.产品ID And g.工序ID = w.工序ID Order by 生产日期 Desc) As 基准数 from {产品工序表} As w ) as d group by 产品id) As k on k.产品ID = a.子阶ID group by