select distinct PersonID
from PersonProject
where ProjectID != '2';
Is this what you are looking for?
Simon
-Original Message-
From: Glenn Wearen [mailto:[EMAIL PROTECTED]]
Sent: 17 July 2001 14:18
To: '[EMAIL PROTECTED]'
Subject: Simple SQL Query?
How can I get a list of all
select distinct PersonID
from PersonProject
where ProjectID != '2';
Is this what you are looking for?
No, what I'm looking for is...
SELECT PersonID
FROM PersonProject
AND PersonID NOT IN (SELECT PersonID
FROM PersonProjectID
Read all about Join in the manual -- it includes hints like this query:
SELECT DISTINCT(PersonID) FROM PersonProject AS P1
LEFT JOIN PersonProject AS P2 ON P2.PersonID=P1.PersonID AND
P2.ProjectID=2
WHERE P2.PersonID IS NULL;
Cheers,
Kent
That is exactly what I want, Thanks Rafal
PS: does anybody know if there are plans to support nested queries in mySQL?
Hi,
maybe something like this:
select a.PersonId from PersonProject a left join PersonProject b
on(a.PersonID=b.PersonID and b.ProjectID=2) where b.PersonID
is null group