> 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:260689
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
