title: Incorrect syntax near the keyword 'INNER'. On Simple SQL query?
body: <p>I am getting an error on a query which worked for another similar task but in this case does not. All I want to do is copy the values from a column in one table to another:</p>
  
  <pre><code>UPDATE   dbo.JobClients 
  SET JobClients.[Status] = dbo.Jobs.[Status]
  INNER JOIN dbo.JobClients 
  ON dbo.Jobs.Id = dbo.JobClients.JobId
  </code></pre>
  
  <p>I added the square brackets around the "Status" because it was highlighting blue and I thought it may be a reserved word, but even so the error isn't pointing to that being the problem:</p>
  
  <blockquote>
    <p><em>Msg 156, Level 15, State 1, Line 3<br>
    Incorrect syntax near the keyword 'INNER'.</em></p>
  </blockquote>
  
  <p>Any ideas greatly appreciated!</p>