这个你要什么数据呢,我想要的结果就是select查询出A B c d四个表的数据 这个是我写的一个SQL 根据A表的ID 查询数据 select * from (select MP.OUTAGE_PLAN_ID,DP.OUTAGE_DEPT_ID,RA.OUTAGE_RANGE_ID,LI.OUTAGE_LINE_ID, LI.SUBSTATION_ID,LI.SUBSTATION_NAME,LI.SUBSTATION_VOLTAGE,LI.LINE_NAME,LI.LINE_ID, LI.LINE_VOLTAGE,LI.DEPT_NAME,LI.DEPT_CODE,LI.DEPT_ID,LI.IS_TURN,LI.IS_OUTAGE from INTEGRATED_OUTAGE_MONTHPLAN MP --A left join INTEGRATED_OUTAGE_DEPT DP on MP.OUTAGE_PLAN_ID=DP.OUTAGE_PLAN_ID --B left join INTEGRATED_OUTAGE_RANGE RA on RA.OUTAGE_DEPT_ID=DP.OUTAGE_DEPT_ID --c left join INTEGRATED_OUTAGE_LINE LI on LI.OUTAGE_RANGE_ID=RA.OUTAGE_RANGE_ID --d ) p where p.OUTAGE_PLAN_ID = 330845;
select MP.OUTAGE_PLAN_ID, DP.OUTAGE_DEPT_ID, RA.OUTAGE_RANGE_ID, LI.OUTAGE_LINE_ID, LI.SUBSTATION_ID, LI.SUBSTATION_NAME, LI.SUBSTATION_VOLTAGE, LI.LINE_NAME, LI.LINE_ID, LI.LINE_VOLTAGE, LI.DEPT_NAME, LI.DEPT_CODE, LI.DEPT_ID, LI.IS_TURN, LI.IS_OUTAGE from INTEGRATED_OUTAGE_MONTHPLAN MP, INTEGRATED_OUTAGE_DEPT DP, INTEGRATED_OUTAGE_RANGE RA, INTEGRATED_OUTAGE_LINE LI where mp.OUTAGE_PLAN_ID = '330845' and mp.OUTAGE_PLAN_ID = DP.OUTAGE_PLAN_ID and dp.OUTAGE_DEPT_ID = RA.OUTAGE_DEPT_ID and RA.OUTAGE_RANGE_ID = LI.OUTAGE_RANGE_ID
这个你要什么数据呢,我想要的结果就是select查询出A B c d四个表的数据
这个是我写的一个SQL 根据A表的ID 查询数据
select * from (select MP.OUTAGE_PLAN_ID,DP.OUTAGE_DEPT_ID,RA.OUTAGE_RANGE_ID,LI.OUTAGE_LINE_ID,
LI.SUBSTATION_ID,LI.SUBSTATION_NAME,LI.SUBSTATION_VOLTAGE,LI.LINE_NAME,LI.LINE_ID,
LI.LINE_VOLTAGE,LI.DEPT_NAME,LI.DEPT_CODE,LI.DEPT_ID,LI.IS_TURN,LI.IS_OUTAGE from
INTEGRATED_OUTAGE_MONTHPLAN MP --A
left join INTEGRATED_OUTAGE_DEPT DP on MP.OUTAGE_PLAN_ID=DP.OUTAGE_PLAN_ID --B
left join INTEGRATED_OUTAGE_RANGE RA on RA.OUTAGE_DEPT_ID=DP.OUTAGE_DEPT_ID --c
left join INTEGRATED_OUTAGE_LINE LI on LI.OUTAGE_RANGE_ID=RA.OUTAGE_RANGE_ID --d
) p
where p.OUTAGE_PLAN_ID = 330845;
DP.OUTAGE_DEPT_ID,
RA.OUTAGE_RANGE_ID,
LI.OUTAGE_LINE_ID,
LI.SUBSTATION_ID,
LI.SUBSTATION_NAME,
LI.SUBSTATION_VOLTAGE,
LI.LINE_NAME,
LI.LINE_ID,
LI.LINE_VOLTAGE,
LI.DEPT_NAME,
LI.DEPT_CODE,
LI.DEPT_ID,
LI.IS_TURN,
LI.IS_OUTAGE
from INTEGRATED_OUTAGE_MONTHPLAN MP,
INTEGRATED_OUTAGE_DEPT DP,
INTEGRATED_OUTAGE_RANGE RA,
INTEGRATED_OUTAGE_LINE LI
where mp.OUTAGE_PLAN_ID = '330845'
and mp.OUTAGE_PLAN_ID = DP.OUTAGE_PLAN_ID
and dp.OUTAGE_DEPT_ID = RA.OUTAGE_DEPT_ID
and RA.OUTAGE_RANGE_ID = LI.OUTAGE_RANGE_ID