title: MySQL: Trying to populate data into one column from another table
body: <p>Table A has several columns, including <code>FirstName</code> and <code>LastName</code>
  Table B has different columns, including <code>FirstName</code>, <code>LastName</code> and <code>EmployeeID</code></p>
  
  <p>I added <code>EmployeeID</code> into Table A. I now want to populate Table A's <code>Employee ID</code>'s from Table B's <code>Employee ID</code>'s, using the first and last name (we currently have no one working with the same name - the design of this table was weird like that)</p>
  
  <p>I've attempted a few things, but I keep coming back to</p>
  
  <pre><code>INSERT INTO TableA (EMPLOYEE_ID) A
  SELECT B.EMPLOYEE_ID FROM TableB B
  WHERE A.First_name = B.First_name
  AND A.Last_name = B.Last_name
  </code></pre>
  
  <p>But I keep getting a syntax error - MySQL server version for the right syntax to use near A. I don't know how to use this syntax when dealing with <code>Insert</code> statements, I think, or if this is the right way at all.</p>