关于oracle多表联合查询的问题
SQL SERVER2000中的多表联合查询程序如下:
SELECT * FROM
(SELECT pp.HTNO, pcd.NAME AS LD1 FROM PUBLiC_PLAN pp JOiN PUBLiC_CODE_DEViCE pcd ON pp.LD_1_iD=pcd.DEViCE_iD WHERE pp.PLAN_STYLE<>-1 ) AS A
LEFT JOiN
(SELECT pp.HTNO, pcd.NAME AS LD2 FROM PUBLiC_PLAN pp JOiN PUBLiC_CODE_DEViCE pcd ON pp.LD_2_iD=pcd.DEViCE_iD) AS B ON A.HTNO = B.HTNO
LEFT JOiN
(SELECT pp.HTNO,pp.PONO ,pp.SG,pp.D_DECiSiON_SG FROM PUBLiC_PLAN pp) AS C ON A.HTNO = C.HTNO
LEFT JOiN (SELECT pp.HTNO, pcd.NAME AS CAST1,pp.D_TiME_SUBTRACT FROM PUBLiC_PLAN pp JOiN PUBLiC_CODE_DEViCE pcd ON pp.CAST_1_iD = pcd.DEViCE_iD) AS D ON A.HTNO = D.HTNO
ORDER BY SUBSTRING(CAST(A.HTNO AS CHAR(6)),2,5)
在oracle10g中怎么实现上述程序的多表查询