[AccessD] Query fails when using NOT IN ???

Christopher

I build graphically ( and this worked ), viewing the code Access
put in some "(" and ")" that might be required.

SELECT output.code
FROM [output]
WHERE (((output.code) Not In (SELECT output_2.code FROM output_2 )));


Dave

----- Original Message ----- 
From: "Christopher Hawkins" <clh at christopherhawkins.com>
To: <accessd at databaseadvisors.com>
Sent: Tuesday, April 20, 2004 9:00 PM
Subject: [AccessD] Query fails when using NOT IN ???


All,

This is weird.  I have a query that is supposed to return all records
from a Time Entry table where the Entry ID is not in the Line Item
table.

So basically, it's "SELECT [field list here] FROM TimeEntry WHERE
EntryID NOT IN (SELECT EntryID FROM LineItem)".

Pretty simple, right?  I can verify that there are a ton of records
in TimeEntry that have no corresponding record in LineItem.  But when
I run the query above, it returns no records.

Any idea?

-C-


-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com