You can use MERGE clause:

MERGE INTO aaa a

USING(

SELECT id_aa ,

id_bb

FROM bbb

)e

ON(a.id_a =e.id_aa)

WHEN MATCHED THEN

UPDATE SET a.id_b =e.id_bb

select * from aaa