Could you verify the exact version you have to work with? Because elsewhere you are talking about SQL92 join syntax (which is A JOIN B ON .....) and that syntax was not introduced in Oracle until version 9.
Yes the database is definitely pre-version 9. It maybe a few choices between 4 and 8 until we finish migrating all the data to 10G by next July. I think I was mistaken, I thought that WHERE ... (+) was the 'SQL92' syntax and that the FROM A JOIN B ON ... was something else. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289628 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
