title: Insert issue Msg 213, Level 16, State 1, Line 2
body: <p>General newbie SQL question probs...</p>
  
  <p>Why doesn't this work - or, what does this mean?</p>
  
  <pre><code>INSERT INTO test_db.dbo.Customers2
    SELECT FirstName
    FROM jas_test_db.dbo.Customers
    WHERE (Customers.FirstName = Firstname)
  </code></pre>
  
  <p>I get:</p>
  
  <blockquote>
    <p>Msg 213, Level 16, State 1, Line 2<br>
    Column name or number of supplied values does not match table definition.</p>
  </blockquote>