title: How to get table name within a 'select' statement in SQL Server
body: <p>I have to make an <code>UNION</code> stament like this more or less:</p>
  
  <pre><code>select [table_name], name, address
  from Employees
  where [my_condition]
  
  UNION
  
  select [table_name], name, address
  from Employees_history
  where [my_condition]
  </code></pre>
  
  <p>The data retrieved will be in either Employees or Employees_history but not in both tables.</p>
  
  <p>I need to know which table the data comes from.</p>