Brian-
Sorry, I do not have any insights on this problem. I am curious, however, what
you intend with that join:
join current_organisation co on exists(select 1
from
user_organisation uo
where uo.ib_username
= p.logon_user_name
and
uo.parameters_organisation_no = co.parameters_organisation_no)
Why code it this way? What are you trying to achieve? As you indicate, looks
bizarre.
Thanks!
Doug C.
