Thanks, Daniel. You are ahead of me. Please add a group by.
DA Morgan wrote:
> Lionel wrote:
>
> > The sql statement looks like this:
> >
> > select a.column1, count(distinct b.id) as nb_b
> > from table1 a, table2 b
> > where a.id = b.a_id (+)
>
> Lets see one non-aggregated column
> One aggregated column ... COUNT(...)
> No GROUP BY clause
>
> I wonder what could be the problem. ;-)
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org
Received on Thu Jul 06 2006 - 15:01:33 CDT
