UPDATE and DELETE with Subselects - IBM DB2 - IBM DB2 ...

One might ask if a subselect like that shown here can be rewritten as a join so that an ... DB2 did not transform the UPDATE statement with a non-correlated ... as much processing as possible in a single SQL statement but there are exceptions.

www.toadworld.com