What if you use this SQL:

SELECT *;
   FROM Property1 B;
   INNER JOIN TTicklers ON TTicklers.Key = B.Key;
   GROUP BY B.Key;
   INTO TABLE (Exp_Prop);
   ORDER BY B.Key

>VFP 6.0. I get the error on the FROM. Can you not b.*?
>
>select b.*
> from tticklers a, property1 b ;
> where (b.key = a.key) ;
> into table (exp_prop);
> group by b.key ;
> order by b.key