Update Query with INNER JOIN

Toad for Oracle
1

Hi Everyone,

Having read another post regarding Update with inner join, I tried to use the same syntax. However I get the following error:

ORA-00933: SQL command not properly ended

The website I used to develop the code is as follows:

http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/06/18/sql-server-update-table-with-inner-join.aspx

My code is as follows:

Update table1

Set table1.occupationcode = table2.occupationcode

From table1

INNER JOIN table2

on reformat_diincdataraw.treatynumber = table2.treatynumber

and table1.polno = table2.polno

and table1.dateofbirth = table2.dateofbirth

and table1.namefamily = table2.namefamily

and table1.dateofextract = table2.dateofextract

Can you please advise where I might be going wrong?

The version of TOAD I am using is 10.6.1.3

Thank You

2

do you get the same error when you run in pure oracle sqlplus with same user?

3

update table1
set table1.occupationcode = (select table2.occupationcode
where table1 INNER JOIN table2
on reformat_diincdataraw.treatynumber = table2.treatynumber
and table1.polno = table2.polno
and table1.dateofbirth = table2.dateofbirth
and table1.namefamily = table2.namefamily
and table1.dateofextract = table2.dateofextract
)

why do you use join “reformat_diincdataraw.treatynumber = table2.treatynumber” and no column from “reformat_diincdataraw” table? This table is sufficient?