这个你要什么数据呢,我想要的结果就是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;