ORACLE UPDATE WITH INNER JOIN ON MULTIPLE ROWS

Asked Oct 18 '18 at 14:34

Active Oct 18 '18 at 14:42

Viewed 490 times

I need to update table AGENT without primary key and unique rows, by the another talbe (select) AGENT_BOSS

Someting like that in MSSQL:

UPDATE AG
SET AGENT_BOSS_ID = AGB.AGENT_BOSS_ID
FROM AGENT AG
INNER JOIN AGENT_BOSS AGB ON (AG.AGENT_ID = AGB.AGENT_ID =)

NOTE: AGENT_ID is not UNIQUE in table AGENT

edited Oct 18 '18 at 14:42

asked Oct 18 '18 at 14:34

Ondřej Mráz

See [here](https://stackoverflow.com/questions/tagged/oracle+sql-update+join) – Oct 18 '18 at 14:42
This is a more precise [link](https://stackoverflow.com/questions/2446764/update-statement-with-inner-join-on-oracle) – Marmite Bomber Oct 18 '18 at 15:06
1

Possible duplicate of [Update statement with inner join on Oracle](https://stackoverflow.com/questions/2446764/update-statement-with-inner-join-on-oracle) – Marmite Bomber Oct 18 '18 at 15:07
1

Important requirement is, that `AGENT_BOSS.AGENT_ID` is backed by a unique index. – Marmite Bomber Oct 18 '18 at 15:09

0 Answers0