If it's a version newer than oracle 8 I believe it can use either notation but the newer form is suggested.
I don't remember which version they added this notation. I believe it falls under the SQL92 standards. Steve -----Original Message----- From: daniel kessler [mailto:[email protected]] Sent: Tuesday, October 27, 2009 1:54 PM To: cf-talk Subject: Re: SQL Join help needed I meant to say - this is Oracle. thanks! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327770 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

