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

Dim cmd As new SQLCommand
cmd.C

Dim tb As Table = Tables(e.Form.Name & "_Table1")
cmd.CommandText = "sele ct a.*,sum(k.基准数) as 基准数"
cmd.CommandText &= " from {SMT_DDPC} as a "

cmd.CommandText &= " left join (Se lect w.产品id,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 k on k.产品ID = a.子阶ID "

老师帮忙看一下，上面红色字的代码应该怎么改。

DDPC中的子阶ID与产品工序表中的产品ID是关联的