You are here

outer join

Filter in WHERE Clause versus Filter in ON clause

Sometimes SQL developers ask me if there is a difference between putting the Filter in the WHERE Clause and putting the Filter in the ON Clause and if yes, what the difference is. To explain it the best I have stolen a little example (Source at the end):

Undefined
Subscribe to RSS - outer join