Could any one tell me which query would be faster and why?

```
(1) select * from userInfo where id in (select id from user)

(2) select a.* from userInfo a,user b where a.id = b.id

```

These are two big tables with 100 million records, I tried it, the (2) query is faster, but I don't know why? Thanks!