[RESOLVED] Query Help

[snoopykiss]

So, I'm pretty proficient at PHP/MySQL, but I'm having a hard time wrapping my head around this problem.

I want to get a list of all member who have NOT received a particular message. Here's a simplified view of the tables:

member
-- member_id
-- member_phone_number

message
-- message_id
-- message_body

outgoing_message
-- outgoing_message_id
-- message_id
-- member_id

What I want to retrieve is a list of member_phone_numbers where they haven't received a particular message (i.e. message_id='3')

I've tried left joins, right joins, but never seem to get the results I'm looking for.

Thanks in advance!
-Tommy.

[snoopykiss]

Whoo! I just did a happy dance as I found out about MySQL's "NOT IN" function.

What I'm looking for is:

select member_id from member
where member_id not in(select member_id from outgoing_message where message_id=67)