Re: Multiple natural joins

Sam Mason wrote:
> On Thu, Mar 19, 2009 at 04:22:56PM +0200, Peter Eisentraut wrote:
>> Joins nest from left to write, so
>>
>> tbl_c NATURAL JOIN tbl_a NATURAL JOIN tbl_b
>>
>> means
>>
>> (tbl_c NATURAL JOIN tbl_a) NATURAL JOIN tbl_b
>>
>> If you want a different order, you can set the parentheses differently,
>> with possibly different results.
>
> When would you get different results?  As far as I can tell, for INNER
> joins, you'd always get the same thing back for any ordering.  With
> OUTER joins it obviously matters what's going on, but that's expected.

Right.