Received: from flex.flex.ro (ns.flex.ro [193.230.255.2])
	by postgresql.org (8.11.3/8.11.1) with ESMTP id f3UEAmg07090
	for <pgsql-interfaces@postgresql.org>;
	Mon, 30 Apr 2001 10:11:01 -0400 (EDT) (envelope-from teo@flex.ro)
Received: from flex.ro (teo.flex.ro [193.230.255.3])
	by flex.flex.ro (8.11.0/8.11.0) with ESMTP id f3UDCmh17519
	for <pgsql-interfaces@postgresql.org>; Mon, 30 Apr 2001 16:12:48 +0300
Message-ID: <3AED712E.30409E16@flex.ro>
Date: Mon, 30 Apr 2001 17:05:34 +0300
From: Constantin Teodorescu <teo@flex.ro>
Organization: PCNet Braila
X-Mailer: Mozilla 4.77 [en] (X11; U; Linux 2.2.17-14 i686)
X-Accept-Language: en
MIME-Version: 1.0
To: PostgreSQL Interfaces <pgsql-interfaces@postgresql.org>
Subject: Re: MULTIPLE OUTER JOIN SYNTAX :-( can't quess it
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200104/136
X-Sequence-Number: 1520

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