How can I get a list of all PersonID's who are not in ProjectID 2 (i.e.
PersonID 3 and 4)?
Table: PersonProject
PersonID| ProjectID
---
1 | 1
2 | 1
3 | 1
1 | 2
2 | 2
1 | 3
2
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
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
