if you're talking about table joins in the from, yes... but I'd like to see an example of a select in a subquery in an update statement.


>Yes, you can, at least in VFP 6 and later (not sure about VFP 5). Here's a line from the VFP 6 Help file:
>
>"UPDATE - SQL can only update records in a single table. Note that subqueries are supported in UPDATE – SQL."
>
>John