-
Help regarding the UPDATE statement
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|