Update Data from one table to another table

Oracle

Note :- Please take data backup before update.

Update (SELECT E.Maxsalary Emx,E.Minsalary Emn,

J.Max_salary Jmx,J.Min_salary Jmn

From TestEmp E,

Jobs J

Where E.Job_id=J.Job_id )

Set Emx= Jmx,Emn=Jmn;