select a.CUST_CD parent,b.CUST_CD child from (SELECT CUST_CD FROM MIT_CUST MC WHERE EXISTS( SELECT ME.COMPANY_CD FROM MIT_EQUIP ME WHERE ME.COMPANY_CD = MC.CUST_CD ) a, (SELECT MC.CUST_CD,substr(MC.CUST_CD,1,2) PCD FROM MIT_CUST MC WHERE EXISTS( SELECT ME.SO_CD FROM MIT_EQUIP ME WHERE ME.SO_CD = MC.CUST_CD) b where a.CUST_CD = b.PCD(+)
(SELECT CUST_CD FROM MIT_CUST MC WHERE EXISTS( SELECT ME.COMPANY_CD FROM MIT_EQUIP ME WHERE ME.COMPANY_CD = MC.CUST_CD ) a,
(SELECT MC.CUST_CD,substr(MC.CUST_CD,1,2) PCD FROM MIT_CUST MC WHERE EXISTS( SELECT ME.SO_CD FROM MIT_EQUIP ME WHERE ME.SO_CD = MC.CUST_CD) b
where a.CUST_CD = b.PCD(+)
谢谢grace,谢谢大家
结贴