select statement join help

From: gareth hoy <ghoy_at_yourplus.com>
Date: 29 Jan 2003 10:56:59 -0800
Message-ID: <e034dbf5.0301291056.3f0f2a53@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:56:59 CST