title: Concat two SELECTS from different tables with different columns
body: <p>I've got two tables.</p>
  
  <p>first</p>
  
  <pre><code>payout_id
  partner_id
  bank_account_id
  old_balance
  amount
  status
  manager_id
  comment
  creation_time
  update_time
  </code></pre>
  
  <p>second</p>
  
  <pre><code>payment_id
  advertiser_id
  type
  bank_account_id
  amount
  status
  manager_id
  comment
  creation_time
  update_time 
  </code></pre>
  
  <p>I've ended up with concatenation of these stuff. These tables don't share any data. I need to sort the result by <code>update_time</code> and apply pagination. Structure is almost similar except the first two columns and one in the middle, so I need just add them leaving one of distinct blank relatively to the table. But the query like</p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT payment_id FROM `advertisers`.`payments`
  UNION
  SELECT payout_id FROM `partners`.`payouts`
  </code></pre>
  
  <p>or</p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT * FROM (
      SELECT payment_id FROM `advertisers`.`payments`
      UNION
      SELECT payout_id FROM `partners`.`payouts`
  ) t
  </code></pre>
  
  <p>shows only the first <code>SELECT</code>'s result.</p>
  
  <p>Quick googling didn't help. Is it even possible? I don't like the idea to do it in the code...</p>