Not able to perform update in delta table in databricks using 3 tables

[Upendra_Kumar]

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]

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]

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]

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