Message-ID: <4095207C.8080009@numerixtechnology.de>
Date: Sun, 02 May 2004 17:23:24 +0100
From: T E Schmitz <mailreg@numerixtechnology.de>
Reply-To: mailreg@numerixtechnology.de
User-Agent: Mozilla Thunderbird 0.5 (Windows/20040207)
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: double left outer join on the same table
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

Hello,

I have two tables SECTION and BRAND. SECTION is related to BRAND via two 
foreign keys. I would like to select ALL SECTIONs whether the FKs are 
null or not and fetch the BRAND attributes in one SQL statement. In 
other words I need a double outer join.

Is this possible at all?

The following doesn't work for two reasons:
a) Table name "brand" specified more than once.
b) how would I specify the same output columns twice?

SELECT
SECTION.SECTION_PK,
SECTION.SECTION_NAME,
SECTION.BRAND_1_FK,
SECTION.BRAND_2_FK,
BRAND.BRAND_PK,
BRAND.BRAND_NAME

FROM SECTION
left outer join BRAND  on BRAND_PK =BRAND_1_FK
left outer join BRAND  on BRAND_PK =BRAND_2_FK


-- 


Regards,

Tarlika Elisabeth Schmitz