title: SQL Server - Need Join but where NOT Equal To
body: <p>I am using SQL Server 2012.</p>
  
  <p>I know how to do an inner join which gives one where there is a match.
  I also need to get the records where there was not match.</p>
  
  <p>What is the best approach. I guess I can do a left join and an inner join and then get the
  ones that are left behind. Wondering what the best and cleanest approach would be.</p>
  
  <p>As mentioned, I am already doing an inner join but also need to show records where there was no match. </p>