[AccessD] SQL question (wich item isn't in the table?)

Sad Der accessd666 at yahoo.com
Wed Aug 13 06:40:18 CDT 2003


Hi,

can anybody help me with this. 
I've got this query:
SELECT DISTINCT cid.ID 
FROM ClientID cid
WHERE cid.ID IN ('156','157')

Model of table ClientID:
(ID number(3))
Data of table ClientID:
ID
157
158
159

It shows all id's from the where clause that are in
the table, wich is 157.

How do I modify it so that it now shows all id's that
are not in the table (156)

thnx

SD

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com


More information about the AccessD mailing list