From: Constantin Teodorescu <teo@flex.ro>
To: PostgreSQL Interfaces <pgsql-interfaces@postgresql.org>
Subject: MULTIPLE OUTER JOIN SYNTAX :-( can't quess it
Date: Mon, 30 Apr 2001 16:55:02 +0300
Message-ID: <3AED6EB6.6D808185@flex.ro> (raw)
Please excuse for my lack of imagination building SQL selects with OUTER
JOINS but something's unclear for me ...
I have 3 tables, t0, t1 and t2.
Tables are:
authors (alias t0) with (id int2, name text);
books (alias t1) with (author int2, title text);
nicknames (alias t2) with (id int2, nickname text);
I want a select query with them with 2 outer joins like that
t0.id = t1.author
t0.id = t2.id
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")
but it says "author table declared more than once".
with just 1 table it worked for me
Please, could you help me quickly showing me the right syntax?
I'm working to add outer joins to visual query builder in PgAccess.
Constantin Teodorescu
Braila, ROMANIA
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: teo@flex.ro
Subject: Re: MULTIPLE OUTER JOIN SYNTAX :-( can't quess it
In-Reply-To: <3AED6EB6.6D808185@flex.ro>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox