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 p
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 p
Thom Brown wrote:
SELECT tbl_a.location, tbl_b.language
FROM tbl_c
NATURAL INNER JOIN tbl_a
NATURAL INNER JOIN tbl_b
The confusion comes when 2 of those tables reference the 3rd table using
the same column.
So are natural joins only allowed to join 2 tables? If not, how can it
be used for m
On Thu, Mar 19, 2009 at 5:24 AM, Thom Brown wrote:
> The confusion comes when 2 of those tables reference the 3rd table using the
> same column.
>
> So are natural joins only allowed to join 2 tables? If not, how can it be
> used for more than 1 table has links to the other tables?
Not sure how
