In this case Fox might not deserve the credit. It is standard ANSI SQL.

>Thank you Mar, Bret and Ken,
>
>Wow, I should have figured that Fox had thought of that.
>
>Alex
>
>>Yes. I believe the following is what you are after. The 2 tables do not have to be open.
>>
>>update table1 set table1.cvar1 = 'aaa' where table1.key in (select table2.key from table2 where table2.field1 between 100 and 200)
>>