>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?].
Mark McCasland
Midlothian, TX USA