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
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly