Re: Oracle sql completed with warnings...

Anthony wrote:
> Can you cut and paste the sql statement and run it directly under
> SQL*PLUS and then
> post both the query and result?

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 (+)

If I remove the outer join or the sum, the warning disapears... nb_b is sometimes null because of the outer join, but the shouldn't be a warning for that. Received on Thu Jul 06 2006 - 05:23:35 CDT