sql update in oracle statement using join

intx

New Member
please where is the error in this statement, I want to update a field1 of table 1 with field2 of table 2 joining both tables on a field 3\[code\]UPDATE (SELECT IP_ANAGRAFICACOMPLESSO.id_complesso, COORDOK6.AZIENDA , IP_ANAGRAFICACOMPLESSO.COORD_GB_E, COORDOK6.WGSE FROM ip_anagraficacomplesso INNER JOIN COORDOK6 ON IP_ANAGRAFICACOMPLESSO.ID_COMPLESSO = COORDOK6.AZIENDA )SET IP_ANAGRAFICACOMPLESSO.COORD_GB_E = COORDOK6.WGSE\[/code\]Thanks a lot
 
Top