Jochem van Dieten wrote: > Several people wrote: >> "ROM table1,table2 WHERE table1.foo = table2.foo (Is NOT ANSI compliant >> SQL)" > > There is nothing wrong with that syntax under any version of the SQL standard > from ANSI or the ISO/IEC. This syntax is not even deprecated in the standard > and I think it is highly unlikelly it ever will be. It is supported by more > implementations then a syntax using the JOIN keyword and there is no way any > implementation is going to deprecate the syntax. The difference in processing > time should be neglegible too. > >
Jochem, Just for clarification, is the outer join syntax that MS-SQL 2005 deprecates (WHERE foo *= blah) non-standard...if so, was it ever standard? I'm afraid I hadn't made a distinction between that and the inner join syntax. Is there ANSI compliant syntax for doing outer joins other than using JOIN? -jim ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253711 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
