title: Incorrect syntax near '.'. While Update a variable table
body: <p>I have an issue while updating a table variable. I've already declared it, however when I run the whole query I get this error:</p>
  
  <blockquote>
    <p>Incorrect syntax near '.'.</p>
  </blockquote>
  
  <p>And I can't seem to solve the issue...</p>
  
  <pre><code>UPDATE @List 
  SET nrID = CASE 
                WHEN nrID IS NULL 
                   THEN t1.nrID 
                   ELSE nrID 
             END 
  FROM @List 
  INNER JOIN table1 t1 ON @List.PNr = t1.PNr
  INNER JOIN table2 t2 ON t1.n nrPNr = t2.nrPNr
  WHERE t1.PNr = t2.PNr AND t2.Isactive = 0
  </code></pre>