Received: from smtp.ualg.pt (smtp.ualg.pt [193.136.224.8]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g1JB6LE10038 for ; Tue, 19 Feb 2002 06:06:26 -0500 (EST) (envelope-from llsousa@ualg.pt) Received: from localhost (smtp.ualg.pt [127.0.0.1]) by smtp.ualg.pt (Postfix) with ESMTP id 89E5A4BB6C; Tue, 19 Feb 2002 11:06:21 +0000 (WET) Received: from ualg.pt (corisco.uceh.ualg.pt [10.10.20.126]) by smtp.ualg.pt (Postfix) with ESMTP id BF3D64BB65; Tue, 19 Feb 2002 11:06:20 +0000 (WET) Message-ID: <3C7231AC.4010808@ualg.pt> Date: Tue, 19 Feb 2002 11:06:20 +0000 From: Luis Sousa User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:0.9.5) Gecko/20011023 X-Accept-Language: en MIME-Version: 1.0 To: Laurent Patureau Cc: pgsql-sql@postgresql.org Subject: Re: SELECT with LEFT OUTER JOIN ON References: <5.1.0.14.0.20020219105716.02593aa8@pop.noos.fr> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS snapshot-20010714 X-Archive-Number: 200202/228 X-Sequence-Number: 6652 Instead of: FROM formation f, ref_unite_de_duree u, ref_unite_de_duree u1 LEFT OUTER JOIN ON (f.unite_duree_entreprise=u.id AND f.unite_duree_totale=u1.id) try: FROM formation f LEFT OUTER JOIN ref_unite_de_duree u ON (f.unite_duree_entreprise=u.id) LEFT OUTER JOIN ref_unite_de_duree u1 ON (f.unite_duree_entreprise=u1.id) I don't know if the results are that you expect but the sintax, I think is correct ! Best regards, Luis Sousa