title: Error using Update Join statement from a Table Variable
body: <p>If I make a table variable here:</p>
  
  <pre><code>declare @Table Table (ProductID int, Color = varchar(60))
  </code></pre>
  
  <p>Then populate it of course, and try to use it in an <code>Update</code> with <code>Join</code> statement like below, I get errors.</p>
  
  <pre><code>UPDATE [Product]
      SET [Product].[Active] = 1                      
      ,[Product].[Color] = t.[Color]
      INNER JOIN @Table t 
      ON t.[ProductID] = [Product].[ProductID]
  </code></pre>
  
  <p>Error:</p>
  
  <pre><code> Msg 156, Level 15, State 1, Procedure
   Incorrect syntax near the keyword 'INNER'.
  </code></pre>
  
  <p>Any suggestions how to do this?</p>