I’m aware that DB2 does not allow joins in update queries; it requires correlated subqueries. That makes writing update queries a bit more complex.
Is there any way to use Query Builder to write these update queries?
-
You can’t add a subquery to an update query in Query Builder
-
If I create my own subquery first, I don’t see a way in Query Builder of using the result of the subquery to update anything in the top level of the query.
Is this functionality not built into Query Builder? What kind of update queries can it model?
Thanks in advance