You can use an asterisk in a nested group by query as long as the group-by table has a single column.
1> select * from t1 2> where c1 in (select * from t2 group by c1) 3> goThe nested group by query example is equivalent to:
1> select * from t1 2> where c1 in (select c1 from t2 group by c1) 3> go