Oracle SQL : UPDATE JOIN

Question

I'm trying to make an update query with a join statement. however, it keeps throwing an error of syntax I'm not really sure where am I going wrong here cause I think I have done it right.

UPDATE AlfaGood 
SET ag.name = 'New text goes here' 
FROM AlfaGood ag 
INNER JOIN SecondAlfa ca ON ca.id = 1 
                         AND ag.agrid = 'Thats my original text';

Please advise on the above if possible. I get an error

ORA-00933: SQL command not properly ended

saying it's missing (; | ,) before FROM

Answer 1

You can do this:

UPDATE AlfaGood ag
   SET ag.name = 'New text goes here' 
--FROM AlfaGood ag -- not an Oracle syntax
 WHERE ag.agrid = 'Thats my original text' 
   AND ag.id = 1 
   AND EXISTS ( SELECT ca.id FROM SecondAlfa ca WHERE ca.id = 1 );