Documents with departments and security settings

select
 archive.eprintid,department,security
from archive,document
where document.eprintid = archive.eprintid and department like '%informacijske%';

Update access to staffonly

begin;
update document set security='staffonly' where eprintid in ( select eprintid from archive where department like '%informacijske%' );
commit;