Re: MULTIPLE OUTER JOIN SYNTAX :-( can't quess it - Mailing list 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