I have a SQL statement that I wrote in 9i. I tried to run it in Visual studio and apparently the oracle data adapter that we are using only recognizes the 8i syntax. I wanted to know if anyone knew how to convert the following statement into its equivilent 9i counterpart...
SELECT DISTINCT CC.CABLE_NUMBER, CD.DRAWING_NUMBER
FROM (CMS_DUC.CABLE CC LEFT JOIN EIDB_DUC.CABLE EC
ON CC.CABLE_NUMBER = EC.CABLE_NO)
I INNER JOIN CMS_DUC.DRAWING CD
ON CC.MASTER_SCHEMATIC = CD.DRAWING_ID
WHERE EC.CABLE_NO Is Null
ORDER BY CC.CABLE_NUMBER ;