Wherever you see that *= syntax you should replace it with the equivalent OUTER JOIN syntax. SQL Server 2005 no longer allows use of that non-standard outer join syntax, unless you run the database in backwards-compatibility mode, which isn't what you want to do.
-Mike Chabot On Fri, Aug 21, 2009 at 8:09 PM, Discover Antartica<discoverantart...@yahoo.com> wrote: > > *= is actually used at my work place. Thanks for the answer. > > > > > ________________________________ > From: Adrian Lynch <cont...@adrianlynch.co.uk> > To: cf-talk <cf-talk@houseoffusion.com> > Sent: Friday, August 21, 2009 5:59:17 PM > Subject: RE: simple SQL Question > > > That is a left outer join. It's mixing new and old styles of joining tables. > Not sure if there's a benefit to the mix, but I reckon this is clearer: > > SELECT a.id, b.name > FROM a > INNER JOIN b ON a.id = b.id > LEFT OUTER JOIN b ON a.id = b.id > > Is this code actually used or an example for the question? > > Adrian > >> -----Original Message----- >> From: Discover Antartica [mailto:discoverantart...@yahoo.com] >> Sent: 22 August 2009 00:50 >> To: cf-talk >> Subject: simple SQL Question >> >> >> what does the *= mean in a query. For example: >> >> select a.id, b.name >> from a >> inner join b >> on a.id = b.id >> where a.id *= b.id >> >> Thank > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:325605 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4