From: T E Schmitz <mailreg@numerixtechnology.de>
To: pgsql-sql@postgresql.org
Subject: double left outer join on the same table
Date: Sun, 02 May 2004 17:23:24 +0100
Message-ID: <4095207C.8080009@numerixtechnology.de> (raw)
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
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: mailreg@numerixtechnology.de
Subject: Re: double left outer join on the same table
In-Reply-To: <4095207C.8080009@numerixtechnology.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