Re: Oracle sql completed with warnings...

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