I have the following 3 tables:
table 1: companies
fields 1: company_id, company name, status
Sample data:
1 , company 1 , 0
2 , company 2 , 1
3 , company 3 , 1
4 , company 4 , 0
5 , company 5 , 1
table 2: groups
fields 2: group_id, group_name
Sample data:
1 , Group 1
2 , Group 2
3 , Group 3
4 ,
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:
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