I am using SQL Server 2012.
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.
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.
As mentioned, I am already doing an inner join but also need to show records where there was no match.