Almost....try
select p.*, g.*
from people p
INNER JOIN grades g ON (p.id = g.peopleid)
where p.id IN (select p.id
from people p
INNER JOIN grades g ON (p.id = g.peopleid)
where g.grade = 'a')
-----Original Message-----
From: Jamie Jackson [mailto:[EMAIL PROTECTED]]
Sent: 28 March 2002 16:48
To: CF-Talk
Subject: Re: Hypothetical SQL question
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.
>
>
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
