i’m not sure this is allowed to use UPDATE keyword with ‘Joined’ table. Seems like it does not like this second table (the one not to be updated).
where (xxxxx/slgrrep.grbss || ‘ ‘ || xxxxx/slgrrep.grggr) =
in ( subselect )
I’ve never seen a library qualifier used as part of a correlation name. Instead of [xxxxx/slgrrep], try just [slgrrep].
And I don’t quite see the logic in the WHERE clause in the first place. You’re taking a couple columns that exist only within the subselect and looking for matches against columns that exist in both the outer UPDATE as well as within the subselect, without identifying which set they should be taken from.
It’s not clear what you’re actually trying to do. It looks like you should have <b>where (yyyyy/slf1rep.f1BSS || ‘ ‘ || yyyyy/slf1rep.F1GGR)</b> and <b>select xxxxx/slgrrep.grbss || ‘ ‘ || xxxxx/slgrrep.grggr
from</b>. I.e., reverse the two column specifications. Since they should have equal values, you shouldn’t care if they’re reversed.
In any case, a description of your intended logic would a long way towards determining what should go where.