Link to home
Avatar of JArndt42
JArndt42Flag for United States of America

asked on

ACCESS SQL

I know what I am looking for but am having a brain freeze on how to get it. I need to get the name of a category that a user is not qualified. I have three tables, tblUsers, tblQualifications and tblQualificationHeader. so I want
 
tblQualificationHeader is where UserName and QualificationID. so i can easily see the categories that say username MONA has qualified for. What I want to see is the categories that MONA is NOT qualified for.

Thanks all.
SOLUTION
Avatar of Dale Fye
Dale Fye
Flag of United States of America image

Blurred text
THIS SOLUTION IS 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.
See Pricing Options
Start Free Trial
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS 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.
Avatar of JArndt42

ASKER

Thank you very much. I have quite a bit to learn of imbedded queries. I will use the second as it seems a smidge quicker.