Query -To set status to Revoked for any resource for any user

update oiu set ost_key=(select ost_key from ost where obj_key=(select obj_key from obj where obj.obj_name = 'AD User') and ost_status='Revoked') where   oiu.orc_key in (
SELECT orc_key  FROM ud_aduser WHERE  ud_aduser_uid in ('test1')) ;
commit;