Serendipityww
Registered User.
- Local time
- Today, 16:02
- Joined
- Sep 6, 2000
- Messages
- 18
How would write sql not exists code to find records of students who have not received earned awards?
I need to look at each student (tblJPerAwardsPacesStatus.fldFamIDFK) who has a status of earned and/or awarded in the tblJPerAwardsPacesStatus.fldStatusIDFK.
I want my query to return a list of students who earned awards but who have not been awarded awards. E.g.,
(these fields are all from the tblJPerAwardsPacesStatus table)
fldFamIDFK....fldPaceNameIDFK.....fldStatusIDFK
19 (Susie).....01 (Lesson 1).........01 (earned)
19...............01........................02 (awarded)
102 (Eric).....01 (Lesson 1).........01 (earned)
I would want my query to return Eric but not Susie because Susie already got her award.
Or if there is a better way, I am open to that.
Thanks for your help.
I need to look at each student (tblJPerAwardsPacesStatus.fldFamIDFK) who has a status of earned and/or awarded in the tblJPerAwardsPacesStatus.fldStatusIDFK.
I want my query to return a list of students who earned awards but who have not been awarded awards. E.g.,
(these fields are all from the tblJPerAwardsPacesStatus table)
fldFamIDFK....fldPaceNameIDFK.....fldStatusIDFK
19 (Susie).....01 (Lesson 1).........01 (earned)
19...............01........................02 (awarded)
102 (Eric).....01 (Lesson 1).........01 (earned)
I would want my query to return Eric but not Susie because Susie already got her award.
Or if there is a better way, I am open to that.
Thanks for your help.