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