Re: Showing Total of Zero using Group By

Use outer join!

JSeeman102 <jseeman102_at_aol.com> wrote in article <19971003234401.TAA24879_at_ladder01.news.aol.com>...
> I'm trying to modify a statistical report that shows a breakdown of
 totals to
> include the records with a total of zero, and I want '0' to be
 displayed.
>
> The SQL*Plus query successfully joins two tables and, using "group by,"
 shows
> the number of times the primary key in the parent table and the foreign
 key in
> the child table match. But my users are also interested in the records
 in the
> parent table that have no match in the child table.
>
> Can anyone think of a way of satisfing the users' request in a single
 query?
> Thanks.
>
> Jeff
>
  Received on Fri Oct 03 1997 - 00:00:00 CEST