Doesn't the count have to be count(*) but otherwise it looks fine to me.
On Sat, Aug 13, 2011 at 3:44 AM, Rick Faircloth <r...@whitestonemedia.com>wrote: > > Hi, guys... > > I've been writing, research, and re-writing a query > over and over trying to get the correct (ie, trustworthy) > results, but can't make it work. > > How would I write a query that would: > > - find all propertyID's from a table that had duplicate photo200 field > values > > I've tried every variation of this I can think of: > > select propertyID, count(photo200) as NumPhoto200 > from rentalphotos > group by photo200 > having NumPhoto200 > 1 > > That's not working. > > Any suggestions, clues, hints?????? > > Thanks! > > Rick > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346727 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm