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