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 join. Anyway, all is well! Thanks, James! Rick -----Original Message----- From: James Holmes [mailto:james.hol...@gmail.com] Sent: Monday, October 04, 2010 9:12 AM To: cf-talk Subject: Re: Can't figure out a query to accomplish this... Are you using select * to get the records? If so, get rid of that and name the select columns from p. select p.area, p.bedrooms, p.bathrooms from ... etc -- WSS4CF - WS-Security framework for CF http://wss4cf.riaforge.org/ On 4 October 2010 11:28, Rick Faircloth <ric...@whitestonemedia.com> wrote: > > Spoke (wrote) too soon... > > I'm getting the correct records, but I just realized > I'm getting two of every field returned. I tried > other joins, but can't affect the fields so that I get > just one field. > > How do I modify the query to return just one field ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:337824 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm