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

Upendra_Kumar
New Contributor

‎02-02-2023 01:47 AM

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..

Labels:
0 Kudos