title: mySQL: Where should i put my WHERE?
body: <p>I'm trying to add a WHERE clause.<br>
  How should i manage it?</p>
  
  <p>This is my Query:</p>
  
  <pre><code>UPDATE  usr_time_reg
  JOIN users  ON usr_time_nr = usr_time_reg.usr_time_nr
  SET usr_time_reg.usr_employment = users.employment;
  </code></pre>
  
  <p>I'm trying to add: <code>WHERE usr_time_reg.usr_emplyoment = "Övrigt"</code></p>
  
  <p>I've tried:</p>
  
  <pre><code>UPDATE usr_time_reg
  JOIN users  ON usr_time_nr = usr_time_reg.usr_time_nr, 
  usr_time_reg.usr_employment = "Övrigt"
  SET usr_time_reg.usr_employment = users.employment;
  
  UPDATE usr_time_reg
  JOIN users ON usr_time_nr = usr_time_reg.usr_time_nr
  SET usr_time_reg.usr_employment = users.employment
  WHERE usr_time_reg.usr_employment = "Övrigt";
  
  UPDATE usr_time_reg
  JOIN users ON usr_time_nr = usr_time_reg.usr_time_nr
  WHERE usr_time_reg.usr_employment = "Övrigt"
  SET usr_time_reg.usr_employment = users.employment;
  
  UPDATE usr_time_reg
  JOIN users ON usr_time_nr = usr_time_reg.usr_time_nr
  AND usr_time_reg.usr_emplyment = "Övrigt"
  SET usr_time_reg.usr_employment = users.employment;
  </code></pre>