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

What are you trying to achieve?  If the ID isn't in the table, then nothing
at all will show.

Doris Manning
Database Administrator
Hargrove Inc.
www.hargroveinc.com


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Sad Der
Sent: Wednesday, August 13, 2003 7:40 AM
To: Acces User Group
Subject: [AccessD] SQL question (wich item isn't in the table?)


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 _______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com