VFP9

have the following SQL that I need to convert from VFP6 to VFP9. I do not want to add an aggregate function to every field in this table that has a lot of fields.

pre.select  b.* ;
from (exp_tick) a, property1 b ;   
where (b.key = a.key) ;
into table (exp_prop);
group by b.key ;
order by b.key

Could I do this instead?

select key from (exp_tick) into cursor cur_exp group by key
select key from property1 into cursor cur_prop group by key
select b.* ;
from cur_exp a, cur_prop b, ;
where (b.key = a.key) ;
into table (exp_prop) ;
order by b.key