You can use an asterisk in the form of qualifier.* (qualifier <period> asterisk), to select only those columns that are in your specified table, such as:
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
