Re: sql statement table join help

"gareth hoy" <ghoy_at_yourplus.com> 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.

Please either look up 'outer join' in your sql course or the sql reference manual or provide the e-mail address of your teacher so we can e-mail him your homework directly.

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address