Showing Total of Zero using Group By

[Quoted] I'm trying to modify a statistical report that shows a breakdown of totals to [Quoted]  include the records with a total of zero, and I want '0' to be displayed.

[Quoted] The SQL*Plus query successfully joins two tables and, using "group by," shows [Quoted]  the number of times the primary key in the parent table and the foreign key in [Quoted]  the child table match. But my users are also interested in the records in the [Quoted]  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