If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#21
|
|||
|
|||
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 . |
#22
|
|||
|
|||
NOT IN (SQL) or Find Unmatched (+ other stuff)
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 |
Thread Tools | |
Display Modes | |
|
|