NOT IN (SQL) or Find Unmatched (+ other stuff)

Sorry, yes, was a typo in copying - 999789 in that line - double checked it
by running it with such

"John Spencer" wrote:

DID you read the following?

=== QUOTE ===
More importantly:
Since query 2 returns 999789 and NOT 99789 I would not expect 99789 to be
excluded from the results of query 4.
=== End Quote ===

I based that comment on the jpegs you posted

The jpeg
http://www.clanimperium.net/2.JPG
shows one record with the serial number of 999789. Your posted query 3
eliminates 99789 with the where clause of
WHERE pd.SERIAL_NUMBER NOT IN ('99789');

Or is that another typo?

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
.

Can you try the same query in MS SQL Server (whatever edition you have, some
are free)? If so, and if you get the same result, then all would point out
that the problem is with the data.

Vanderghast, Access MVP