Multiple outer join on same table - Mailing list pgsql-sql

From Marco Lazzeri
Subject Multiple outer join on same table
Date
Msg-id 1076350332.31616.45.camel@macbeth.intranet.noze.it
Whole thread Raw
Responses Re: Multiple outer join on same table  (Markus Bertheau <twanger@bluetwanger.de>)
Re: Multiple outer join on same table  (Greg Stark <gsstark@mit.edu>)
List pgsql-sql
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




pgsql-sql by date:

Previous
From: Mark Gibson
Date:
Subject: Re: Implementation of a bag pattern using rules
Next
From: "scott.marlowe"
Date:
Subject: Re: techniques for manual ordering of data ?