Thomas Lockhart <lockhart@alumni.caltech.edu> writes:
> In some cases, an outer join with WHERE restrictions reduces to
> an inner join (so the qualification clauses can be consolidated).
I recall you having muttered something about that before, but I don't
see how it works. Can you give an example of an outer join that
reduces to an inner join?
regards, tom lane