Need help with one SQL query for two tables !

I need to get all members from members table except
members with an id found in blocked table's member_id field ...

Can it be done in ONE query and if ... How should the query look?

Sample db structure:

Table 1: members | Field: id, name, email, url
Table 2: blocked | id, member_id

$MySQL = "
SELECT id, name, email, url FROM members
WHERE [id NOT found in blocked's member_id field - I'M LOST HERE]
ORDER BY id
";

Any sql guru here? - Sample snippet pleeeease

 

Try this -

OR Use SQL 'Join' function

 

Thank you Webmaster, this is just what I needed

Are they exactly the same to use, or is one better than the other,
thinking about performance, speed etc, etc ?

 

I think the second query will perform a little better, but it won't make a huge difference

 

'Join' is always good to use.
But since you have only two table and few fields you can use any of them..