title: Error Code: 1222. The used SELECT statements have a different number of columns
body: <p>I'v tried a few statements including joins, but have not been able to insert data from three other MySQL tables into one. On my last attempt, I received this error: Error Code: 1222. The used SELECT statements have a different number of columns
  Please see below for the query I entered.
  (I'm new to coding, so I'm still pretty much a novice with MySQL. Any help is appreciated. Thanks.)</p>
  
  <pre><code>INSERT INTO cases (person_id, last_name, first_name, date_applied) 
  SELECT person_id, last_name, first_name, 
  date_applied FROM person  UNION SELECT (program_name) FROM program 
  UNION SELECT (status) FROM casestatus
  </code></pre>