Pulling results depending on another table

Can anyone help me with this one

SCenario

I have two tables (let call them table 1 and table 2)

I wish to pull the email from table 1 where the user id in table two is equal to the user id in table 1.

I've tried this but no luck

SELECT email from table1 WHERE table2.id == table1.id;

Come on you brainy bunch show me how dumb that was and what the correct syntax is

Cheers

Gary Mailer

Manuals are your friends.
Read the mysql manual about JOIN statements.

You are really just a few chars away from a working statement.

SELECT email from table1 WHERE table2.id == table1.id

should be:

SELECT email from table1,table2 WHERE table2.id = table1.id;

note the single "=" statement.

If you also have an "email" field in your table2, you must identify which of the two email fields you want to get: "table1.email"