Re: MULTIPLE OUTER JOIN SYNTAX :-( can't quess it

From: Constantin Teodorescu <teo(at)flex(dot)ro>
To: PostgreSQL Interfaces <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: MULTIPLE OUTER JOIN SYNTAX :-( can't quess it
Date: 2001-04-30 14:05:34
Message-ID: 3AED712E.30409E16@flex.ro
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Constantin Teodorescu wrote:
>
> Tried :
> select t0.name, t1.title, t2.nickname from authors t0 left outer JOIN
> books t1 ON (t0."id"=t1."author") , authors t0 left outer join nicknames
> t2 on (t0."id"=t2."id")

:-) After 30 seconds I have found the answer :

select t0.name, t1.title, t2.nickname from authors t0 left outer JOIN
books t1 ON (t0."id"=t1."author") left outer join nicknames
t2 on (t0."id"=t2."id")

Constantin Teodorescu
Braila, ROMANIA

Browse pgsql-interfaces by date

  From Date Subject
Next Message Tom Lane 2001-04-30 14:24:24 Re: [INTERFACES] function returning NULL?
Previous Message Constantin Teodorescu 2001-04-30 13:55:02 MULTIPLE OUTER JOIN SYNTAX :-( can't quess it