title: Query to display rows having duplicate values in 2 columns
body: <p>I have Table1:</p>
  
  <pre><code>id|name|city
  -------------
  1 | bat|nyc
  2 | cat|del
  2 | rat|bom
  3 | mat|xyz
  </code></pre>
  
  <p>Table2</p>
  
  <pre><code>id|name|city
  --------------
  1 |bat|dsada
  2 |cat|sadasd
  3 |rat|sdasdas
  2 |rat|asdas
  </code></pre>
  
  <p>I need a query to display rows where BOTH id and name are same among two tables in above example the query must return 
  i need a query to display the rows </p>
  
  <pre><code>1|bat|nyc
  2|cat|del 
  </code></pre>
  
  <p>from first table</p>