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=u.id
AND f.unite_duree_totale=u1.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.
____________________________________
Laurent Patureau
S.A.R.L. ID.fr
mailto:lpatureau@idfr.net
http://www.idfr.net
Porter un nouveau regard à votre audience :
http://www.wysistat.com
Tel : 03 81 48 03 13
Fax : 03 81 48 04 83
16,
Boulevard Winston Churchill
25 000 Besançon
___________________________________