>Your syntax is correct. However, subqueries are not currently supported in VFP UPDATE - SQL commands.
>
Mark:

Thanks for the reply. I thought what I had should work based upon this comment from the help screen

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

Is there some other sub-query that is supported, or is this a mistake???

Thanks again.........Rich