view related sql works in 8i not in 9i

[pitre]

Hi

just try to do a: SELECT UNIQUE to be certain to have one record returned by the subquery.

Perhaps Oracle want a "group by" to got an unique record ...