I am wanting to see if there is a way to do a join but
have count(id) show up as 0 when there is no records in
the 2nd table. With out having to 2 selects.
for example.
orderid = has persons name and contact info
select oi.id,oi.name, count(o.id) from orderid oi, orders o
where
select oi.id,oi.name, count(o.id) from orderid oi LEFT OUTER JOIN orders
o
ON o.order_id = oi.id group by oi.id,oi.name ;
-Original Message-
From: Charles Verge [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 03, 2002 11:53 AM
To: [EMAIL PROTECTED]
Subject: join count and 0
