Suppose this:

I want to select all the names and addresses of people who have their name in table1 and table2. i can achieve this, for instance, with this two select statements:

1) select a.name, a.address from teste1 as a inner join test2 as b on a.name=b.name

2) select name,address from table1 where name in (select name from table2)

Wich of this two querys is faster? and why?

Thank you