I have the following two queries.
<!--- Get all sessions from category --->
<CFQUERY NAME="rsCatSessions" DATASOURCE="DB">
SELECT Quiz, QString
FROM QCat, Quiz
WHERE mcat = '#URL.cat#' AND scat = '#URL.scat#' AND QCat.QID = Quiz.Qstring
ORDER BY Quiz ASC
<!--- Get the passed sessions from the category --->
<CFQUERY NAME="rsTakenPass" DATASOURCE="DB">
SELECT DISTINCT Scores.QString
WHERE Scores.QString = #rsCatSessions.Qstring# AND username = '#session.username#' AND score >= 90
The first query returns a set of ID's that I match up later with their friendly names. The data may look like:
The second query compares what was returned in the first query to the scores table to see what has been passed. The data may look like:
I need help with a query that will show those items that exist in the first query and NOT in the second. That data would look like:
Thanks in advance!