Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 424
  • Last Modified:

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?
0
PetGuy
Asked:
PetGuy
1 Solution
 
Rey Obrero (Capricorn1)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

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now