Query in msaccess

I have a query that returns a list of product numbers.
I have a second query that has a list of product numbers that I want to exclude from the first queries list.
how do I do this?
PetGuyAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
create a query like this

select Q1.*
from Q1
left join Q2 on Q1.productnumber=Q2.productnumber
where Q2.productnumber is null




.
0
 
Luke ChungPresidentCommented:
You are looking for a Not-In Query. Here's a paper I wrote with examples of how to do it: http://www.fmsinc.com/MicrosoftAccess/query/outer-join/index.html
0
All Courses

From novice to tech pro — start learning today.