OK. Thanks to you and Nadya for the information.......Rich
>>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
>
>The subquery example Nadya provided is supported. The subquery as you used is not supported in VFP. It is correct SQL syntax when used in SQL databases like Oracle [and SQL Server?].