Re: Need some query help

Hi,

Ok. The merge statement is 9i and up. Not available in 7.
The statement won't work, because you can't update a query with a group
by. Oracle needs to be able to decide a rowid to update, and group by
prohibits this.

The only other alternative I can think of for the moment is to use a
temporary table.

Regards,

Arian

.