What is the difference between usign joins vs IN.
Joins example:

SELECT Table1.* FROM Table1 INNER JOIN Table2 ON Table1.field1 = Table2.field2

IN example:

SELECT Table1.* FROM Table1 
WHERE field1 IN (SELECT field2 FROM Table2)

Result will be the same.
Which query will be quicker?