title: Add "field" of table name to SQL results from UNION?
body: <p>If I have a simple union</p>
  
  <pre><code>select name, phone from users union select name, phone from vendors;
  </code></pre>
  
  <p>Is there a way to add the table name to the results?</p>
  
  <p>So instead of</p>
  
  <pre><code>+--------+-------+
  | name   | phone |
  +--------+-------+
  | Jim    | 123...|
  | Macy's | 345...|
  +--------+-------+
  </code></pre>
  
  <p>I'd get</p>
  
  <pre><code>+--------+-------+---------+
  | name   | phone | table   |
  +--------+-------+---------+
  | Jim    | 123...| users   |
  | Macy's | 345...| vendors |
  +--------+-------+---------+
  </code></pre>