asked on MySQL Query Syntax
Hoping you can give me the query syntax to exclude all volunteers already signed up for ProjID=2.
I need to send reminder email but don’t want to send to those already signed up.
The query below worked when only 1 Project. I was thinking of replacing the tVolProjInt table with a query that only includes current Proj.
SELECT tVol.ID, tVol.title, tVol.fname, tVol.sname, tVol.gender, tVol.salutation, tVol.maidenName, tVol.signUpDate, tVol.shul, tVol.occupation, tVol.empID, tVol.email, tVol.address1, tVol.address2, tVol.suburb, tVol.cellNo, tVol.tellNo_H, tVol.tellNo_W FROM tVol LEFT JOIN tVolProjInt ON tVol.ID = tVolProjInt.volID WHERE tVolProjInt.volID IS NULL;
tVolProInt has only some of the records contained in tVol.
Hope given enough info
Thanks
I need to send reminder email but don’t want to send to those already signed up.
The query below worked when only 1 Project. I was thinking of replacing the tVolProjInt table with a query that only includes current Proj.
SELECT tVol.ID, tVol.title, tVol.fname, tVol.sname, tVol.gender, tVol.salutation, tVol.maidenName, tVol.signUpDate, tVol.shul, tVol.occupation, tVol.empID, tVol.email, tVol.address1, tVol.address2, tVol.suburb, tVol.cellNo, tVol.tellNo_H, tVol.tellNo_W FROM tVol LEFT JOIN tVolProjInt ON tVol.ID = tVolProjInt.volID WHERE tVolProjInt.volID IS NULL;
tVolProInt has only some of the records contained in tVol.
Hope given enough info
Thanks
MySQL ServerSQL
Last Comment
Arana (G.P.)
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.