Hi Friends,
I am using Oracle 10g and I am trying to run below query to 'update' table using 'join':
I am getting error while running this query. I am not able to find out the exact cause of this error. Please let me what changes I need to do to run this query without ant error.UPDATE TABLE T01 SET T01.Champ01 =SELECT T02.Champ01
FROM TABLE T02
TABLE INNER JOIN T01 ON T01.Champ02 = T02.Champ02
Bookmarks