title: Compare two tables and select records based on two conditions - not exists and no match
body: <p>I have two tables and need to compare based on the first and last name. The scenario is like that name exists in one but not in other. The other scenario is name exists but not matching because of typo error etc. I can get non matching records using NOT EXISTS but how will i display the name thats in table2 also?
  My output table should have three columns like below -</p>
  
  <p>SL.No---Not Exists in Table2--- Name in Table2</p>
  
  <p>Any suggestions appreciated.</p>
  
  <p>Arun</p>