Update query using joins in oracle

I needed to do t1. FirstName, t1. LastName on a table after matching it on the "UserName" column t1. The database was such where it was using UserName as a primary key to UserInfo everywhere, instead of placing FirstName and LastName in the table, directly.

This fixed that! This answer adds nothing to the answer already provided by Quassnoi five years before yours. This following syntax works for me. Jim Garrison Hemant Hemant 49 1 1 bronze badge. JimGarrison Please re-edit this answer so I can remove my downvote I was trying to use this syntax and it wasn't updating my table.

I thought the syntax was merely updating a temp table instead of the real one, but I was wrong. Janek Bogucki Janek Bogucki 4, 2 2 gold badges 27 27 silver badges 39 39 bronze badges.

Phil 1, 6 6 gold badges 22 22 silver badges 42 42 bronze badges. Dan Anderson Dan Anderson 29 2 2 bronze badges. Hi Dan. You are posting to a pretty old question that already has very good answers. Can you explain when you question is preferable over the other solutions? A but there's no need to point the table. You are actually updating fields from the view, which get mapped to the table.

If the inner view were aliased h, then the "self-documenting" version would be "set h. CODE from table2 t2 where t1. Just as a matter of completeness, and because we're talking Oracle, this could do it as well: declare begin for sel in select table2.

Edu Castrillon Edu Castrillon 1 1 gold badge 12 12 silver badges 26 26 bronze badges. This could do it, but it's about the slowest way possible. Oracle base has a good run down on this. Rob Rob 2, 5 5 gold badges 34 34 silver badges 51 51 bronze badges. Athafoud 2, 2 2 gold badges 39 39 silver badges 53 53 bronze badges.

The Overflow Blog. Podcast Making Agile work for data science. Stack Gives Back Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. This is a guide to Oracle Update with Join. Here we discuss the definition, syntax, and How update with join works in Oracle?

You may also have a look at the following articles to learn more —. Submit Next Question. By signing up, you agree to our Terms of Use and Privacy Policy. Forgot Password? This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy.

By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy. Oracle Update with Join. Popular Course in this category. Course Price View Course. All Sign in options. Enter a Email Address. Choose your interests Get the latest news, expert insights and market research, sent straight to your inbox. Newsletter Topics Select minimum 1 topic. I want to join two tables and update a single column as This statement is giving errors.

Ananthram Venugopal Posted May 9, 0 Comments. Donald Biddle Posted May 9, 0 Comments. Helen Yelluas Posted May 10, 0 Comments. I use this method: update a,b set a. Bryan Watson Posted May 10, 0 Comments.