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

Take a look at this page on SQL-Guru

http://www.sql-guru.com/Deutsch/tips/tip17.html

> -----Original Message-----
> From:	Charlotte Foust [SMTP:cfoust at infostatsystems.com]
> Sent:	Wednesday, August 13, 2003 12:18 PM
> To:	Access Developers discussion and problem solving
> Subject:	RE: [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
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com