That works too. Thanks Dave.
Thanks, Mark -----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, November 16, 2006 11:56 AM To: CF-Talk Subject: RE: SQL Problem > I'm stumped on this. How to I retrieve records that do not match (I'm > wanting to display orphaned Companies that are not associated with > Projects). Tried <> and using NOT and NOT > IN() without success. > > SELECT C.company, C.companyID, C.companyCity, C.companyState, > C.companyZip, > P.companyID > > FROM dbTable_Clients_Companies_List C, dbtable_Clients_Projects_List P > > WHERE C.companyID <> P.companyID > > ORDER BY C.company ASC SELECT c.company, c.companyID, c.companyCity, c.companyState, c.companyZip FROM dbTable_Clients_Companies_List c WHERE c.companyID NOT IN (SELECT p.companyID FROM dbtable_Clients_Projects_List p) Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore and Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260702 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
