Use Table-Name Qualifiers

You can use an asterisk in the form of qualifier.* (qualifier <period> asterisk), to select only those columns that are in your specified table.

For example:

1> create table t1(c1 int, c2 int)
2> go
1> create table t2(c1 int)
2> go
1> select * from t1 
2> where c1 in (select t2.* from t1, t2)
3> go

The nested select statement is equivalent to:

1> select * from t1 
2> where c1 in (select t2.c1 from t1, t2)
3> go