title: SQL problems with UPDATE SET FROM WHERE statements
body: <p>I'm very bad at SQL so I'm struggling to UPDATE using values coming from separate tables:</p>
  <p>I need use values inside 2 different tables as well as values from PHP script as part of an update query into a third table. with help I was able to make this statement but im getting syntax errors</p>
  <p>ou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from<br />
  order1
  join supplier
  on supplier.Order_ID = order1.order_ID
  join pr' at line 6</p>
  <p>My code is here:</p>
  <pre><code> update order1
      set Reorder_Time=supplier.Reorder_Time,
          Amount_Ordered=&quot;123456789&quot;,
          Stock_Amount=product.Stock_Amount,
  from order1
      join supplier on supplier.Order_ID = order1.order_ID 
      join production on supplier.Product_ID = product.Product_ID
  where orderId = &quot;123456789&quot;
  </code></pre>