title: How to select rows from two tables where both have the same value in the same field?
body: <p>I have two tables that have the same column names.</p>
  
  <p>There is a field called <code>Call_Status</code> in both tables.</p>
  
  <p>I want to retrieve the records having <code>Call_Status="Open"</code> from both tables. i.e. I want a query that can retrieve all the records of <code>table1</code> having <code>call_Status="Open"</code> &amp; then from <code>table2</code> having <code>call_Status="Open"</code></p>
  
  <p>I have no idea how to do this and would appreciate some guidance</p>