title: Insert on 3 joins MYSQL
body: <p>What I am trying to do is to insert records from multiple tables into 1 table by joining. Here is what I have and I can't seem to get it to work. I get the following error #1136 - Column count doesn't match value count at row 1</p>
  
  <pre><code>INSERT INTO users(`name`, `email`,`location_id`, `department_id`)
  VALUES('John Doe', 'jdoe@email.com', 1, 1)
  
  INSERT INTO extensions(`ext`)
  VALUES(98765)
  
  INSERT INTO dids(`did`)
  VALUES('1-800-555-5555')
  
  INSERT INTO users_numbers(user_id,ext_id,did_id) 
  SELECT extensions.*, dids.*, users.*
  FROM extensions tbl_ext, dids tbl_dids, users tbl_users, users_numbers usn
  Inner Join users ON users.id=usn.user_id 
  Inner Join extensions ON extensions.id=usn.ext_id 
  Inner Join dids ON dids.id=usn.did_id
  WHERE tbl_users.name = 'John Doe' 
  AND tbl_users.email = 'jdoe@email.com' 
  AND tbl_ext.ext = 98765 
  AND tbl_dids.did='401-559-9999';
  </code></pre>
  
  <p>The first 3 insert statements work. The error fires on the 4 insert when I try to join. Can anyone help.</p>