Hi Adam, this is absolute magic getting a reply within 1/2 hour and a
working solution at that!
Here's the correct syntax :
SELECT
SECTION.SECTION_PK,
SECTION.SECTION_NAME,
SECTION.BRAND_1_FK,
SECTION.BRAND_2_FK,
b1.BRAND_NAME,
b2.BRAND_NAME
FROM SECTION
left outer join BRAND as b1 on b1.BRAND_P
On 2/5/04 5:23 pm, "T E Schmitz" <[EMAIL PROTECTED]> wrote:
> 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 w
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 followin
