Re: SQL question

From: (wrong string) é Klück <akluck01_at_wxs.nl>
Date: Thu, 09 Jul 1998 22:53:15 +0200
Message-ID: <35A52DBB.10D1_at_wxs.nl>


Dan,

Check out OUTER JOIN.
In your case if table1.column1 has no corresponding occurence in table.column it DOES return a row, giving all the selected columns from table1 and NULLs in the selected columns from table.

In case there is a corresponding occurence also the selected columns from table will give theirs values.

sUCCes,
André

Dan wrote:
>
> Using this SQL example,
>
> table.column (+) = table1.column1
>
> could someone explain the symbol (+)? I've not seen it before and can't
> find a reference to it in the Oracle SQL manual. Any help would be greatly
> appreciated!!
>
> Thanks,
> Dan
Received on Thu Jul 09 1998 - 22:53:15 CEST

Original text of this message