title: "From is not valid at this position" this is the syntax error I am getting while using Update join in mysql-Workbench
body: <p><a href="https://i.stack.imgur.com/PRtP0.png" rel="nofollow noreferrer">enter image description here</a>I want to update the Paid column in Product when payment amount get inserted with respect to the product...</p>
  <pre><code>create table Product(
  PID INT primary key,
  Paid int not null default 0 ,
  Total int not null
  );
  
  
  
  create table payment(
  paymentid int primary key,
  productid int not null,
  amount int not null,
  foreign key (productid) references product(paid)
  );
  
  (I am just using the dummy table to practice update using join)
  
  
  update product 
  set product.paid=(pay.amount+pr.Paid)
  from-----&gt; here I am getting error
  payment pay 
  inner join product  pr on
  pay.productid=pr.pid;
  </code></pre>