Obviously first one
because in first query both the table will be scanned only for condition a.name=b.name
In second query whole table2 will be scanned then it will be compared with table1.
Also it depends on the size of the tables too
Sanket Ahir
Don't run behind the success, Try to be eligible & success will run behind u......