select * from ims_md_relation_resource where ims_md_re_re_id = :ims_md_re_re_id and ims_md_re_id = :ims_md_re_id update ims_md_relation_resource set identifier = :identifier where ims_md_re_re_id = :ims_md_re_re_id select rere.identifier, rere.ims_md_re_re_id, re.ims_md_re_id, re.ims_md_id from ims_md_relation_resource rere, ims_md_relation re where rere.ims_md_re_id = :ims_md_re_id and re.ims_md_re_id = :ims_md_re_id