In any join query, when you select *, you'll get all columns from both tables you've joined. It doesn't matter if the columns are named the same; since they are in different tables they are providing different data and are returned as separate columns.
-- WSS4CF - WS-Security framework for CF http://wss4cf.riaforge.org/ On 4 October 2010 21:59, Rick Faircloth <ric...@whitestonemedia.com> wrote: > > Yes, once I got the query working (except for the duplicate fields) > I swapped to "select *" to avoid having to type the 50 or so fields > involved. It works elsewhere, so I figured it should here. > > But as soon as I starting specifically naming the fields, the > duplication cleared up. > > I would love to know why, but I guess that's just the way MySQL > works with that particular query. Perhaps it's the way it has > to be done with a left joi ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337827 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm