Cross Check Two Tables

[t5amec]

I have two tables "Tbl2a" and "Tbl2b". These tbls contain details of invoices, matched and not matched.

Tbl2a is the earliest report and Tbl2b is after the update.

I have worked out the way to find invoices that were on Tbl2a as not matched then on Tbl2b matched.

But I need to know how to query invoices that weren't even on Tbl2a and are matched on Tbl2b.

Any helpers?

Make Sense? I hope so (-:

 

[PHV]

Something like this ?
SELECT B.*
FROM Tbl2b AS B LEFT JOIN Tbl2a AS A ON B.PrimaryKey = A.PrimaryKEY
WHERE B.Matched = True AND A.PrimaryKey Is Null;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[t5amec]

Is Null isn't working for me. Is there any other way?

Make Sense? I hope so (-:

 

[PHV]

Is Null isn't working for me
Any error message ? Unexpected result ?
To get accurate answer, please post well formed question.
Feel free to take a look at either one FAQ in my sig.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[t5amec]

No messages.

Its just not displaying any results, and I know that some should be there.

Make Sense? I hope so (-: