Todd Payne Commented 1 Years ago through
Blogs | 1 Point
One thing to remember when using outer joins is that the ON predicate is logically processed before the OUTER JOIN puts the rows back in and before the WHERE clause.
So
SELECT
t1.Name,
t2.Amount
FROM
t1 LEFT OUTER JOIN t...