Update a table from selecting another table

[marist89]

Instead of the IN clause, you can:
update emp x
set sal = (select sal from temp0430 y where y.empno=x.empno)
where x.empno = y.empno