SELECT mit NOT EXISTS

[Hans Huber]

Hi,

i need a SELECT for my Database but I dont know how to do it. Probably its easy but im searching now for 3 hours in the web and don't find a clou to this. So here is the thing...

I have 3 Tables

Table 1 person with person_id
Table 2 groups with a group_id
table 3 assign where assign the group_id to the person_id and give it a status 1 or 0

I want to know all person_id's who have the group_id=1 with status=1 and group id=4 with status=0 AND the people who have group_id=1 with status=1 and group_id=4 does not exist.

Can someone help me with that?

Thanks a lot for your help.