表结构如下
TABLE1 ID,no
TABLE2 ID,PID,CID
TABLE1 ID,T1ID,PRODUCTNAME查询语句如下:
select LEVEL,b.id,b.PID,ep.no PNO,b.CID,ec.no CNO
from TABLE2 b
inner join TABLE1 ep on ep.id = b.pid and b.wkaid = 1 and ep.wkaid = 1
inner join TABLE1 ec on ec.id = b.cid and b.wkaid = 1 and ec.wkaid = 1
LEFT JOIN TABLE1 P ON EP.ID=P.T1ID
start with eP.no IN(SELECT PRODUCTNAME FROM TABLE3) connect by prior Cid = Pid
返回列 level,ID,PID,CID,PNO,CID,CNO
现在想返回level,ID,PID,CID,PNO,CID,CNO,TABLE1.PRODUCTNAME
这个TABLE1.PRODUCTNAME要求是start with中使用的那个TABLE1.PRODUCTNAME
,请问高手如何做?
TABLE1 ID,no
TABLE2 ID,PID,CID
TABLE1 ID,T1ID,PRODUCTNAME查询语句如下:
select LEVEL,b.id,b.PID,ep.no PNO,b.CID,ec.no CNO
from TABLE2 b
inner join TABLE1 ep on ep.id = b.pid and b.wkaid = 1 and ep.wkaid = 1
inner join TABLE1 ec on ec.id = b.cid and b.wkaid = 1 and ec.wkaid = 1
LEFT JOIN TABLE1 P ON EP.ID=P.T1ID
start with eP.no IN(SELECT PRODUCTNAME FROM TABLE3) connect by prior Cid = Pid
返回列 level,ID,PID,CID,PNO,CID,CNO
现在想返回level,ID,PID,CID,PNO,CID,CNO,TABLE1.PRODUCTNAME
这个TABLE1.PRODUCTNAME要求是start with中使用的那个TABLE1.PRODUCTNAME
,请问高手如何做?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货