Thanks for the info.

>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)
>>>