Skip to content Skip to sidebar Skip to footer
Home / Db2 / Sql / Sql Update

Db2 Sql Update Correlating With Subquery

Post a Comment
Code block: update yrb_purchase px set px.club = (select club from (select p.title, p.year, o.club, o.price, ROW_NUMBER() OVE

Solution 1:

To reference preceding tables, try including the LATERAL keyword in the nested table reference:

update yrb_purchase px
  set px.club = (select club fromLATERAL (select p.title, p.year, o.club, ...

Don't have a DB2 9.7 instance to test it but I think it should work.

Post a Comment for "Db2 Sql Update Correlating With Subquery"