pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Marco Lazzeri <marcomail@noze.it>
To: pgsql-sql@postgresql.org
Subject: Multiple outer join on same table
Date: Mon, 09 Feb 2004 19:12:13 +0100
Message-ID: <1076350332.31616.45.camel@macbeth.intranet.noze.it> (raw)

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';
==

Thanks,
Marco

view thread (3+ messages)  latest in thread

Message-ID: <1076350332.31616.45.camel@macbeth.intranet.noze.it>
Permalink:  ../1076350332.31616.45.camel@macbeth.intranet.noze.it/
Also on:    postgresql.org/message-id/1076350332.31616.45.camel@macbeth.intranet.noze.it

copy link · copy postgr.es

reply

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: marcomail@noze.it
  Subject: Re: Multiple outer join on same table
  In-Reply-To: <1076350332.31616.45.camel@macbeth.intranet.noze.it>

* 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