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

If the ID isn't in the table, how do you know what it is?  Is there a
table that contains all IDS that should exist, or are you looking for
gaps in consecutive numbers?

Charlotte Foust

-----Original Message-----
From: Sad Der [mailto:accessd666 at yahoo.com] 
Sent: Wednesday, August 13, 2003 4:53 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] SQL question (wich item isn't in the table?)


that's just it. I need to prove that a lot of ID's
aren't in the table!

I really would like to find these ID's using a sql.
that way I do not have to create an extra function,
object or whatever.

SD
--- Mike and Doris Manning <mikedorism at ntelos.net>
wrote:
> 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
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com


__________________________________
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