title: select * from two tables with different # of columns
body: <p>How would I select different columns from two different tables, such as:</p>
  
  <pre><code>SELECT username, email FROM `table1` 
  UNION
   SELECT * FROM `table2` WHERE username = 'user1';
  </code></pre>
  
  <p>I'm getting an error <code>"#1222 - The used SELECT statements have a different number of columns"</code>. From what I understand UNION will not work,</p>
  
  <p>Is there a way to accomplish this, since I would need unequal number of columns and rows <strong>and</strong> there are no mutual/similar entries in the two tables (i.e. user1 is not listed in table1)?</p>
  
  <p>Can this not be done in one query?</p>
  
  <p>thank you!</p>