I need to update Table_1 based upon a select of data from two other tables "ROLD" and "PP";
My Oracle Sql is not correct. Can someone tell me how to modify the query below so that it is syntactically correct?
(Table_1.Id = ROLD.Id,
Table_1.FName = ROLD.FName,
Table_1.LName = ROLD.LNAME,
Table_1.PurchasePrice = PP.PurchasePrice
(FROM ROLD,PP WHERE ROLD.ID = PP.ID);