Hi,
I have a scenario where i need to update few columns in table A from table B and table C.The problem is there is no relation between tables B & C. Following is the query in SQL server:
Update A set A.column1 = B.column1,
A.COLUMN2 = C.column2
From
tableA A
inner join
tableB B on (join condition)
inner join
tableC C on (join condition);
I don't want to prepare separate updates for both the tables. I've read in few forums that oracle update doesn't support joins and the only work around is using merge. Also I don't want to prepare a sub query or a temp table by joining tables A,B & C. Any help in this regard would be appreciated.