HELP PLZZZZ (can i use NOT IN for this case???how to???)

[marco_pb via AccessMonster.com]

Thank you all in advance to read this.

I have a problem. I have a query of qualified students and I have a table
that has information of the qualified on who has already register.
The probel is, I want to have a query to show the qualified students but has
not regitered yet.
Help please. I dont know how to make the query.

Thank you again in advance..

example:
query A (qualified stu.) table B (qualified n registered stu.)
name: name:
A C
B
C

QUERY that I want to have:
name:
A
B

How to make it? thank you...

 

[Svetlana]

Try this:
SELECT [query A].Name
FROM [query A] LEFT JOIN [table B] ON [query A].Name = [table B] .Name
WHERE ((([table B] .Name) Is Null));

 

[marco_pb via AccessMonster.com]

thanks a lot..
I really dont know how to thank you.. I am a noob in using access..

thank you once again..
have a nice day and Gbu

Try this:
SELECT [query A].Name
FROM [query A] LEFT JOIN [table B] ON [query A].Name = [table B] .Name
WHERE ((([table B] .Name) Is Null));