Hello there, I do appreciate this isn't the right forum for posting this question but I have posted my question in the SQL forum but I haven't heard anything back. It's a very straightforward query... at least I hope it is for someone with good sql skills.
I was hoping someone could help here. I have a table called 'phone_numbers' with two columns, one called 'person_name' and the other called 'number'. A person can have more than one number and I want the query to return all person's that have more than 3 numbers. Jamie 1 Jamie 2 Jamie 3 Jamie 4 Allan 5 Vicki 6 Marilyn 7 Paul 8 Scott 9 Scott 10 Scott 11 Scott 12 So in the above example, the query would return Jamie and Scott. How do I get this data? Regards, John ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314540 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
