title: Display the table name in the select statement
body: <p>I need to display the table name in the select statement. how?</p>
  
  <p>exact question:</p>
  
  <p>we have common columns in two tables. we are displaying the records by using </p>
  
  <pre><code>select column_name from table_name_1 
  union
  select column_name from table_name_2
  </code></pre>
  
  <p>But the requirement is, we need to display the source table_name along with the data. 
  consider a,c are present in table_1 and b,d are present in table_2. </p>
  
  <p>we need the output in the following way</p>
  
  <p>eg: </p>
  
  <pre><code>column_name                     table_name
  a                                          table_1
  b                                          table_2
  c                                          table_1
  d                                          table_2
  .......................................................
  ......................................................
  </code></pre>
  
  <p>Is this possible</p>