>Tsoi,
>
>VFP does not allow a SELECT inside of an UPDATE command. You can change your code to;
>

Man,

Someone has to get the 7.0 doc corrected then.. from the help:

UPDATE - SQL can only update records in a single table. Note that subqueries are supported in UPDATE – SQL.

BOb