title: Can I include the table name in the result of an SQL query?
body: <p>If I have two tables:</p>
  
  <pre><code>Actor:
  ID | Name
  1  : Patrick
  3  : Emma
  7  : Vanessa
  
  Singer:
  ID | Name
  4  : Will
  5  : Madonna
  13 : Emma
  </code></pre>
  
  <p>Can I generate the following table from an SQL query, which contains the table name each record came from?</p>
  
  <pre><code>ID | Career | Name
  1  : Actor  : Patrick
  3  : Actor  : Emma
  4  : Singer : Will
  5  : Singer : Madonna
  7  : Actor  : Emma
  13 : Singer : Emma
  </code></pre>
  
  <p>I'm assuming the ID column items are unique across the two tables, but not the names.</p>