Hope this helps :)
<cfset goodgrade = "A">
<CFQUERY name="getgradeA" datasource="datasource">
Select Distinct people.people,
grades.grades
FROM grades,
people
Where people.people_id = grades.people_id
AND grades.grades = '#goodgrade#'
</CFQUERY>
Steven Lancaster
Barrios Technology
NASA/JSC
281-244-2444 (voice)
[EMAIL PROTECTED]
-----Original Message-----
From: Cantrell, Adam [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 10:32 AM
To: CF-Talk
Subject: Hypothetical SQL question
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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
