sql语句: with cte(id_cpbom,XH,level,BH,CPBH,SJS,BZ) as ( select id_cpbom,XH,0 level,BH,CPBH,SJS,BZ from CPBOM
where CPBH='QSJ57-00-00-000' union all
select b.id_cpbom,b.XH,level+1,b.BH,b.CPBH,b.SJS,b.BZ from CPBOM b inner join cte c on b.BH = c.CPBH)
select XH,level,BH,cte.CPBH as CPBH,CPMC,SJS from cte,WLML where WLML.CPBH=cte.CPBH
group by id_cpbom,XH,level,BH,cte.CPBH,CPMC,CPTH,SJS,BZ order by level
得到的结果举例:QSJ48-00-20-000的实际用量=QSJ57-00-00-000的用量数*QSJ48-00-20-000的用量,下面的子部件都这样求到,请教大家,sql语句应该如何写呢?谢谢