title: Appending one sql query with another
body: <p>I have a datareader that binds a sql select (with 10 columns from table1) , i want to append another with 5 different cols from table2 to this first sql select, i can't do UNION as it has different number of columns, (one query has 10, another returns 5 cols).</p>
  
  <p>Is there any other way of implementing this, via mysql?</p>
  
  <p>Also i need to append the additional 5 columns based on a condition, is there via mysql select query to write with using if then in the select query?</p>
  
  <p>Thanks.</p>