title: Oracle update using multiple tables
body: <p>Can someone help me with this sql statement to run on Oracle? I am new to Oracle. I tried different ways, but getting syntax error. With this statement I get <code>Missing SET keyworkd</code> error, if I remove employee, I get invalid column name for emp_id.</p>
  
  <pre><code>update emp_bonus, employee                                                               
  set emp_bonus.bonus = '555'                        
  where emp_bonus.emp_id = employee.emp_id and emp_bonus.bonus_id  = '101';
  </code></pre>