Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sql statement table join help
Just use an OUTER JOIN. Look at any basic SQL book for more information.
ghoy_at_yourplus.com (gareth hoy) wrote in message news:<e034dbf5.0301291056.8d7e2ea_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 - 19:01:55 CST