ORA-00904: "E2"."FID_E2": invalid identifier
**********************************************************************
*******SQL************************************************************
SELECT TOP 1000 E0.FID,E0.F_MODEL_CODE,E0.F_REASON1,E1.FID AS FID_E1,E1.F_REASONTYPE,E1.FNAME,E2.FID AS FID_E2,E2.F_MODELTYPE,E2.FNUMBER,E2.F_PLATFORM,E2.F_CARVENDOR,E2.FNAME AS FNAME_E2
FROM (
SELECT T0.FID AS FID,T0.F_MODEL_CODE AS F_MODEL_CODE,T0.F_REASON1 AS F_REASON1
FROM PABR_T_QM_CFFAULTINFO T0 ) E0
INNER JOIN (
SELECT T0.FID AS FID,T0.F_MODELTYPE AS F_MODELTYPE,T0.FNUMBER AS FNUMBER,T0.F_PLATFORM AS F_PLATFORM,T0.F_CARVENDOR AS F_CARVENDOR,T0_L.FNAME AS FNAME
FROM PABR_T_QM_QM_MODELCODE T0
LEFT JOIN PABR_T_QM_QM_MODELCODE_L T0_L ON (T0.FID=T0_L.FID AND T0_L.FLOCALEID=2052) ) E2 ON E0.F_MODEL_CODE = E2.FID_E2
INNER JOIN (
SELECT T0.FID AS FID,T0.F_REASONTYPE AS F_REASONTYPE,T0_L.FNAME AS FNAME
FROM PABR_T_QM_QM_REASONINFO T0
LEFT JOIN PABR_T_QM_QM_REASONINFO_L T0_L ON (T0.FID=T0_L.FID AND T0_L.FLOCALEID=2052) ) E1 ON E0.F_REASON1 = E1.FID
推荐阅读