title: How to check both table having same row values Even Rows are mismatch?
body: <p>I have Two table consider tbl1 and tbl2</p>
  
  <pre><code>   tbl1 
  
     Site
     ---------
     101 - Hold
     102 - test
  
     tbl2
  
     Site
     ---------
     101 - Hold
     104 - wel
     102 - test
  </code></pre>
  
  <p>I want to check tbl2 data is present in tbl1 . If yes select statement has to return  'Yes' else 'No' ...</p>
  
  <pre><code>EXample
  If tbl2 is not having "102-test" then also i have to return 'No'
  </code></pre>
  
  <p>How can i achieve this. </p>