Simple query

[vavs]

I think this should be a simple query but I am not getting the results I am looking for.

I have two tables, each with a single column of data containing Purchase Order numbers.

I need to find if a number exists in the first table but not in the second table.

The query I used was:

Select PONUM
from PS,AV
where PS.PONUM <> AV.PONUM

I basically end up with all of the rows from PS.PONUM

I am an ACCESS novice. I can do this in Excel but the number of rows (160000) is too much to handle in Excel.

 

[Joe4]

Try using the Find Unmatched Query Wizard. It will walk you through all of the steps (and you can view the SQL when done, if you like).

Simply click on New from the Query Object section and select "Find Unmatched Query Wizard"

 

[MyBoo]

Try using the Find Unmatched Query Wizard. It will walk you through all of the steps (and you can view the SQL when done, if you like).

Simply click on New from the Query Object section and select "Find Unmatched Query Wizard"

Just to add to the above:
Once you create the Unmatched Query, via the Wizard, test it to make sure it works, then open it in Design mode, click on the down arrow of the View button (left-most button in tool bar) and click on SQL View. This will show you the correct syntax for what you were trying to do. Might be helpful.