title: Sql search in multiple tables
body: <p>I have a database with multiple tables i.e table1, table2, table3 with same fields. Somehow I can't merge these tables into one. </p>
  
  <p>Is there any way to query them one after another for same criteria such that if the record is found in the first table return the found record otherwise search in second table and so on. 
  like:</p>
  
  <pre><code>Select * from table1 where cloumnX = 'xyz'
  if found return the rocord
  else
  Select * from table2 where cloumnX = 'xyz'
  ...
  
  Select * from lastTable where cloumnX = 'xyz'
  </code></pre>