From: Markus Bertheau <twanger@bluetwanger.de>
To: Marco Lazzeri <marcomail@noze.it>
Cc: pgsql-sql@postgresql.org
Subject: Re: Multiple outer join on same table
Date: Wed, 11 Feb 2004 22:23:26 +0100
Message-ID: <1076534606.1984.8.camel@yarrow.bertheau.de> (raw)
In-Reply-To: <1076350332.31616.45.camel@macbeth.intranet.noze.it>
References: <1076350332.31616.45.camel@macbeth.intranet.noze.it>
On Пнд, 2004-02-09 at 19:12 +0100, Marco Lazzeri wrote:
> Hi!
> I'm searching a better (quicker) way to retrieve data as I used to do
> using the following query...
>
> ==
> SELECT
> main.codice,
> other.value AS value_one,
> other.value AS value_two
> FROM main LEFT OUTER JOIN other ON main.id =
> other.id_main
> LEFT OUTER JOIN other AS other2 ON main.id =
> other2.id_main
> WHERE
> other.type = 'type_one'
> AND other2.type = 'type_two';
> ==
You can alias a table to join it to itself. I'm not sure whether that
answers your question.
SELECT t1.field FROM table AS t1 JOIN table as t2 on (cond)
--
Markus Bertheau <twanger@bluetwanger.de>
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-sql@postgresql.org
Cc: twanger@bluetwanger.de, marcomail@noze.it
Subject: Re: Multiple outer join on same table
In-Reply-To: <1076534606.1984.8.camel@yarrow.bertheau.de>
* 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