This forum is for Database developer ( PostgreSQL, MySQL, SQL Server, Oracle etc...) and database Administrator
2 posts • Page 1 of 1
How to Update two column of one table from another table in Oracle SQL? I tried but not able to update correctly more than one column.
Below query is working for me. Update two column of TableA from TableB.
update TableA A set (A.First_name, A.Last_Name)= (Select B.First_name, B.Last_Name
from TableB B where A.EMp_ID=B.Emp_ID)
Users browsing this forum: No registered users and 1 guest