Db2 update sql

I really need to use a single query, it's the point of my work — Luka. Luka, for that you have to make like I said now in the answer : — aF. Luka - please update your question with the revised requirement. Also, please note that the second example here will only be garuanteed to work if either the two columns will accept null s, or the selection from table2 will always return a row.

Show 3 more comments. Yes it is possible. Tested under DB2 Tim Seed Tim Seed 4, 2 2 gold badges 26 26 silver badges 25 25 bronze badges. Vlad Troyan Vlad Troyan 2 2 silver badges 4 4 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown.

Active 2 years, 11 months ago. Viewed 9k times. Improve this question. Add a comment. Active Oldest Votes. Improve this answer. Joe Taras Joe Taras Sign up or log in Sign up using Google.

Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Helping communities build their own LTE networks. Podcast Making Agile work for data science. Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually.

Related 3. Hot Network Questions. Question feed.