Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Update Statement with Join

user8413118Nov 8 2019 — edited Nov 11 2019

Hello Oracle Community,

i got some hard task for me, don´t know if it is even possible. For now all my tries ended in different errors.

So here ist the question, ist it possible to update Table1 with the corresponding nlfdTable3 number, getting

this about a join to Table2.nlfdTable2 and Table3.sTextTable2? Only matching entries should be updated.

It´s only made once to convert some data. Can this be done with one SQL Statement?

pastedImage_0.png

Thanks in advance
This post has been answered by Solomon Yakobson on Nov 9 2019
Jump to Answer
Comments
Post Details
Added on Nov 8 2019
10 comments
19,694 views