Hi all,
We are running on Oracle 10g. The following script results in ORA-00928: missing SELECT keyword. Any ideas what causes this error? Both 'select' statements when run by themselves, complete successfully.
[code]
WITH A1 AS
WITH A1 AS ( SELECT MIN (VAPS_RPT_INTV_DMSN.INTV_DT), VAPS_RPT_INTV_DMSN.RPT_ID, VAPS_RPT_INTV_DMSN.RPT_INTV_ID FROM APS.VAPS_RPT_INTV_DMSN, APS.VAPS_RPT_CL_INTV_DMSN WHERE APS.VAPS_RPT_INTV_DMSN.RPT_INTV_ID = APS.VAPS_RPT_CL_INTV_DMSN.RPT_CL_INTV_ID AND VAPS_RPT_INTV_DMSN.HM_VST_IND = '1' GROUP BY VAPS_RPT_INTV_DMSN.RPT_ID, VAPS_RPT_INTV_DMSN.RPT_INTV_ID ORDER BY VAPS_RPT_INTV_DMSN.RPT_ID, VAPS_RPT_INTV_DMSN.RPT_INTV_ID) A2 AS ( SELECT DISTINCT TAPS_REFERRALS_FACT.RPT_ID, TAPS_REFERRALS_FACT.DB2_UPDATE_DT, TAPS_REFERRALS_FACT.RPT_RECV_DT FROM APS.TAPS_REFERRALS_FACT, APS.VAPS_RPT_CL_DMSN, APS.VAPS_RPT_CL_INTV_DMSN WHERE VAPS_RPT_CL_DMSN.RPT_ID = TAPS_REFERRALS_FACT.RPT_ID AND VAPS_RPT_CL_INTV_DMSN.RPT_CL_ID = VAPS_RPT_CL_DMSN.RPT_CL_ID AND TAPS_REFERRALS_FACT.EMRG_IND = '1' ) SELECT * FROM A1, A2 WHERE A1.RPT_INTV_ID = A2.RPT_INTV_ID
[/code]
Thank you,
Seyed