Databricks Community

Upendra_Kumar · ‎02-02-2023

Hi,

I am able to perform merge from 2 tables but have requirement to update table based on 3 tables like following query.

update a

set a.name=b.name

from table1 a

inner join table2 b on a.id=b.id

inner join table3 c on a.id=c.id

Thanks in advance..

Cami · ‎02-02-2023

it can be a workaround ( it just crossed my mind) but you can try to join those tables in a data frame and after that select columns for A table with new value for a.name column. Save data frame and as a temporary table and make merge with A table.

Anonymous · ‎02-08-2023

Hi @upendra kumar sharma

Hope all is well! Just wanted to check in if you were able to resolve your issue and would you be happy to share the solution or mark an answer as best? Else please let us know if you need more help.

We'd love to hear from you.

Thanks!

Anonymous · ‎04-08-2023

Hi @upendra kumar sharma

Help us build a vibrant and resourceful community by recognizing and highlighting insightful contributions. Mark the best answers and show your appreciation!

Thanks and Regards