The rules for using scalar subqueries with UPDATE (Upsert Form) requests are the same as those for simple UPDATE requests, except for the following additional rule:
- Because the UPDATE component of an upsert operation must be a simple update, you cannot specify a correlated scalar subquery in its SET clause or its WHERE clause.