*= 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:325601 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4