Received: from smtp.noos.fr (lafontaine.noos.net [212.198.2.72]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g1JA1IE03911 for ; Tue, 19 Feb 2002 05:01:19 -0500 (EST) (envelope-from lpatureau@idfr.net) Received: (qmail 12496656 invoked by uid 0); 19 Feb 2002 10:01:19 -0000 Received: from unknown (HELO idfrportable.idfr.net) ([195.132.30.156]) (envelope-sender ) by 212.198.2.72 (qmail-ldap-1.03) with SMTP for ; 19 Feb 2002 10:01:19 -0000 Message-Id: <5.1.0.14.0.20020219105716.02593aa8@pop.noos.fr> X-Sender: lpatureau@pop.noos.fr X-Mailer: QUALCOMM Windows Eudora Version 5.1 Date: Tue, 19 Feb 2002 11:00:59 +0100 To: pgsql-sql@postgresql.org From: Laurent Patureau Subject: SELECT with LEFT OUTER JOIN ON Mime-Version: 1.0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Archive-Number: 200202/227 X-Sequence-Number: 6651
Hi,
my query is :

CREATE VIEW "vue_formation" AS SELECT
f.numero_formation,
f.intitule_1 || ' ' || f.intitule_2 || ' ' || f.intitule_3 AS intitule,
f.convention,
f.subvention,
f.effectif_conv,
f.eff_subv,
f.rythme_1 || ' ' || f.rythme_2 || ' ' || f.rythme_3 AS rythme,
f.duree_entreprise || ' ' || u.nom || ' ' || f.commentaire_duree AS duree_entreprise,
f.public_1 || ' ' || f.public_2 || ' ' || f.public_3 AS public,
f.admission_1 AS admission_1,
f.admission_2 || ' ' || f.admission_3 AS admission_2,
f.unknown_3 AS ref_admission,
f.statut AS statut,
f.duree_totale || ' '|| u1.nom AS duree_totale
FROM formation f, ref_unite_de_duree u, ref_unite_de_duree u1
LEFT OUTER JOIN ON (f.unite_duree_entreprise=3Du.id
AND f.unite_duree_totale=3Du1.id)
ORDER BY intitule

There's a mistake near the ON, I don't find any example using join condition on postgres.org/idocs
Is anybody could help me (correct syntax or link with example).
I find the doc on it not really complete.

rgds,



Laurent Patureau.
____________________________________
          =             &nb= sp; Laurent Patureau
            &nb= sp;            =    
S.A.R.L. ID.fr

            &nb= sp;   mailto:lpatureau@i= dfr.net

            &nb= sp;         http://www.idfr.net=

    Porter un nouveau regard =E0 votre audience :
            &nb= sp;      http://www.wysistat= .com

            &nb= sp;        Tel : 03 81 48 03 13
            &nb= sp;        Fax : 03 81 48 04 83

           16, Boulevard Winston Churchill
            &nb= sp;         25 000 Besan=E7on
___________________________________