title: update on inner join of 2 tables with where clause
body: <p>I am trying to do an update on an inner join of 2 tables with a where clause.
  I currently have a select that get's the results I want to update. But I keep getting an error while trying to do the update.
  Here is my SELECT that works : </p>
  
  <pre><code>SELECT a.rd_1, total_points 
  FROM bracket.ticket as a
  Inner join bracket.picks as b 
  where 
  b.team_ID = 31 AND a.ID = b.ticket_ID
  </code></pre>
  
  <p>And here is my update that doesn't work</p>
  
  <pre><code>UPDATE a 
  set a.rd_1 = a.rd_1 + 1 
  FROM bracket.ticket as a
  Inner join bracket.picks as b 
      where 
      b.team_ID = 31 AND a.ID = b.ticket_ID
  </code></pre>
  
  <p>I have also tried this:</p>
  
  <pre><code>UPDATE a 
  SET a.rd_1 = a.rd_1 + 1 
  FROM bracket.ticket as a
  Inner join bracket.picks as b 
      on a.ID = b.ticket_ID
  where 
  b.team_ID = 31 AND a.ID = b.ticket_ID
  </code></pre>
  
  <p>There error I get here is:
  Syntax error: 'FROM' (from) is not a valid input at this position.</p>
  
  <h2>ticket</h2>
  
  <p>ID | rd_1 | total_points</p>
  
  <h2>picks</h2>
  
  <p>ID | ticket_ID | team_ID</p>