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
> 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
