Tricks with SQL: Beware of the Predicate in the Outer Join

Uli Bethke SQL

Today we will have a look what happens when we place a filter condition into an outer join. We will also have a look at how this compares to placing the filter condition into the WHERE clause. Finally we'll have a look where this could be useful. Let's first create some sample data.

Let's run our first outer join ...