Simple SQL Statement....broken brain...

[D. Shane Fowlkes]

I'm stumped! I know this isn't exactly a .NET question but I know someone
here is bound to be able to help. I'm trying to write a query to extract a
list of records from a many-to-many "key" table where the records are not
within a list of possible matches. For example:

SELECT ContactID, CategoryID
FROM CategoryMatches
WHERE CategoryID Not In (16,19,20,35,39)
ORDER BY ContactID


This query STILL returns records from this table where a CategoryID listed
above is found. A sample table and query can be downloaded here:
http://www.easterassociates.com/sample.mdb (164kb) It's probably easier
just to see the query and table itself.

THANKS for helping!

 

[Guest]

Check to make sure the data type of the ID is not some form of character
data. Other than that, the query looks correct.

Unable to download the database (file not found), so I am not sure what the
issue is there.

---

Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************

 

[D. Shane Fowlkes]

I'll check but the file is definitely there....

TIA

 

[D. Shane Fowlkes]

Yep...all fields are "Long Integers" (MS Access versions).

 

[Guest]

you have a many-to-many relation ship in one table
i recommend that you split this tables in tree tables
one for contactInfo ,one for category info and one that have id's that link
between to two tables