SQL Tip: LEFT JOINs and WHERE clauses…are they really LEFT JOINs?

There are times when I review SQL queries and find people using LEFT OUTER JOINs but then use WHERE clauses that turn those joins into INNER JOINs. Recently as I mentioned this to someone they reminded me that I should blog about it...so here I am blogging about it. 🙂 First off, if you aren't … Continue reading SQL Tip: LEFT JOINs and WHERE clauses…are they really LEFT JOINs?