I have two tables. say EMP and EMPINFO

Both the tables contains two columns say empid and empno

The EMPNO coulmn is null in the table EMP.

Now i want to update EMP table and set the values of EMPNO based on the EMPID in the tables EMP and EMPINFO.

Can we use rowid in this??or any other optimazation query to do this??

Please help.