说明:将多行(包含父子关系)树状查询结果符合条件的父子关系记录按照符号进行等级层次拼接组成每行结果;其中包含两种SQLServer和Oracle数据库的查询方式,仅供参考,目前正在学习中,当中有语法不规范处请勿对号入座。
1. 【SQLServer】"树查询"拼接语句如下:
With SubQuery (upmaterialnumber,qty,subPartNo,SumDrawingNumber) AS
(Select
R.upmaterialnumber,
R.qty, R.materialnumber as subPartNo,
C.SumDrawingNumber as SumDrawingNumber
From ERP_D_MeterialRelation R,ERP_D_BillOfMaterial C
Where R.materialnumber = '6A100045'
And R.materialnumber = C.number
Union All
Select
A1.upmaterialnumber,
A1.qty,A1.subPartNo,
B1.SumDrawingNumber
From ERP_D_BillOfMaterial B1,
(Select
A.upmaterialnumber,
A.qty,