More then likely I am not fully understanding the differences between the two. However I am trying to figure out how many people from my optout table are actually in my client table. I tried two different ways and thought they would return the same count...

Method One:

```
Select count(*) from `optout`
    where fname in (Select fname from client)
    and lname in (Select lname from client)
    and state in (Select state from client);

```

Method Two:

```
Select count(*) from `optout` as t1
    join `client` as t2
        on t1.fname = t2.fname
           t1.lname = t2.lname
           t1.state = t2.state;

```

Which way would be the correct way to handle this? Method One returns 5,000+ records and Method Two only returns 258.