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

Stuart McLachlan stuart at lexacorp.com.pg
Tue Apr 20 20:19:14 CDT 2004


On 20 Apr 2004 at 19:00, Christopher Hawkins wrote:

> 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.
> 

Is EntryID the same datatype in both tables? 

As another thought, make sure that you haven't "quoted" the subquery 
in your actual code..

Maybe pasting the actual code would help.






 
-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System 
Support.






More information about the AccessD mailing list