select * from people, grades where people.id = grades.peopleID and people.id in ( select people.id from people, grades where people.id = grades.peopleID and grades.grade = 'a' )
Something like that? May have screwed up something in there, but that's how I'd do it. Jamie On Thu, 28 Mar 2002 10:31:30 -0600, in cf-talk you wrote: >Hypothetical SQL question: > >I have a table called PEOPLE and a table called GRADES. I'd like to return a >list of people and all of their grades and then output the results in a >cfoutput, grouping by peopleID. Ok, that's easy enough, but what if I only >want to return people that have an A as one of their grades? What type of >condition do I use to achieve this? Currently I'm able to pull the people >that have an A, but it won't return the other grades, so it ends up with a >bunch of people with just one or more A's - it won't show their B's, C's, >and D's. > >This seems way to easy, but I'm struggling with it this morning for some >reason, maybe someone can give me a little push. > >Adam. > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists