mysql set membership query

[blackhorse]

1) we can query set membership on one column, such as id

select * from tb1 where id in ('1', '2', '3')

2) we can also use subquery, this time, we can query set membership on multiple columns, such as (id, name)

select * from tb1 where (id, name) in (select id, name from tb2)

3) my question would be, if I cannot use subquery, how can i query set membership on multiple columns, such as (id, name)

select * from tb1 where (id, name) in ("what should I put here if I am not using subqeury")

Thanks!

[bradgrafelman]

Do an INNER JOIN between tb1 and tb2, using both id and name in the join condition.

[Lars_Berg]

select * 
  from tb1 
 where (id, name) in ((1,'Somebody'),(2,'else'),(3,'has'),(4,'newer'))