Oracle uses a plus sign (+) in the where clause to indicate an outer join.
"gareth hoy" <ghoy_at_yourplus.com> wrote in message
news:e034dbf5.0301291056.3f0f2a53_at_posting.google.com...
> Hi,
>
> i have 2 tables seller and manager.
>
> seller:
>
> seller_id
> ----------
> 01
> 02
> 03
> 04
> ----------
>
> manager:
>
> seller_id manager_id
> --------- ----------
> 01 a
> 02 a
> 03 b
> -----------------------
>
> as you can see from the tables seller "04" does not have a manager. I
> am trying to do a select statement that would output the following:
>
> seller_id manager_id
> --------- ----------
> 01 a
> 02 a
> 03 b
> 04
> -----------------------
>
> When you do a normal table join select statement, seller "04" is not
> included in the output as seller "04" does not exist in the manager
> table.
>
> What is the syntax for including seller "04" in the select output even
> though there is no entry in the manager table.
>
> please help,
> thanks,
>
> Gareth.
Received on Wed Jan 29 2003 - 12:59:33 CST
