Re. Is it possible to have an outer join with the Group By in the same query?

Did you try nested select?

select symbol, max(transadate) from (
select s.symbol symbol, a.transDate transdate from symbols s, account a
where s.symbol=a.symbol (+))
group by symbol

I have done this a few times and am sure this will work.

SaraN
vishmayaa_at_yahoo.com Received on Fri Mar 02 2001 - 12:35:44 CST