That worked perfectly!!! Thanks so much :-)
-Original Message-
From: Diana Soares [mailto:[EMAIL PROTECTED]
Sent: Friday, December 05, 2003 10:31 AM
To: Robert Hughes
Cc: [EMAIL PROTECTED]
Subject: Re: Need help with query. Please!
Try:
SELECT C.company_id, C.company_name
FROM
Try:
SELECT C.company_id, C.company_name
FROM companies C
LEFT JOIN company_group_intersect CG
ON (C.company_id=CG.company_id AND CG.group_id='1')
WHERE C.status='1' AND CG.company_id IS NULL
--
Diana Soares
On Fri, 2003-12-05 at 15:08, Robert Hughes wrote:
> I have the following 3 tables:
