How to Update a Table using Join?

Question

Do i need to write in PL/SQL or is it possible in SQL query?

Answer 1

Joins are used in SQL, where we want to fetch the records from two tables.

You can update via Join using following query.
UPDATE employee e LEFT JOIN employee_salary s ON e.id=s.employee_id
SET s.salary='50000'
where e.first_name='Admin';