Schau dir obige Syntax doch an:

update file set field='Status'
where key in (select key from file2 where fieldx='Bedingung')