Re: Outer Join and Group By

>>
>I did a query like this:
>
> select IN_NUMBER, IN_NAME, sum(OUT_AMOUNT)
> from INNER, OUTER
> where IN_NUMBER = OUT_NUMBER (+)
> and OUT_MONTH >= '9504'
> group by IN_NUMBER, IN_NAME;
>

You need to add the outer join operator (+) to every column in the table you're doing the outer join with.

	select IN_NUMBER, IN_NAME, sum(OUT_AMOUNT)
	  from INNER, OUTER
	  where IN_NUMBER = OUT_NUMBER (+)
	    and OUT_MONTH (+) >= '9504'
	  group by IN_NUMBER, IN_NAME;

Tony Damon Received on Thu Aug 03 1995 - 00:00:00 CEST