I have to update one table from another one: I can do the update with the MySQL sgbd:
update product pr , provider p set pr.provider_name = p.name where p.provider_id = pr.provider_id ;
but when I try to do it with oracle : I tried this query for oracle
UPDATE pr SET pr.provider_name = p.name FROM product pr INNER JOIN provider p ON p.provider_id = pr.provider_id ;
I get this error:
Error Code: 933, SQL State: 42000] ORA-00933: SQL command not properly ended
What's wrong with my query?