update fieldvalue set STRING_FIELD_VALUE='Transaction Done' where STRING_FIELD_VALUE='Warten auf ERP Status' and id in (select fv.id from PROD p
inner join ident i on i.ID=p.ident_id
inner join fieldvalue fv on fv.owner_id=p.id and fv.name = 'exd_Style_text_22'
where 
 i.codeAlpha1 in ('602424', '602024', '603024', '603224', '605624', '605824', '606824', '608224', '607424', '607224', '607624', '729824', '607824', '608024', '608424', '608624', '608824', '609224', '609424', '609824', '609624', '610024', '610824', '611024', '724424', '730624', '730424', '731424', '723624', '730024', '731224', '724824', '731024', '729624', '729224', '728624', '728824', '729424', '730824', '725024', '729024', '731824', '732024', '732424', '732224', '724429', '730429', '751424', '752624', '752024', '751824', '750624', '751024', '750424', '752424', '750824', '752824', '751224', '750829', '751429', '750429', '751229', '751829', '752029', '731429', '730229', '728229', '729629', '728629', '728829', '725029', '704424', '710624', '710424', '711424', '703624', '710024', '711224', '704824', '710224', '708224', '709824', '711024', '709624', '709224', '708624', '708824', '709424', '710824', '705024', '709024', '731625', '752224', '611624', '611424', '611824', '612024', '761824', '762024', '723024', '722624', '722424', '762824', '763224', '763624', '764024', '764424', '764624', '763024', '763424', '763824', '764224', '756289', '726289', '762224', '760024', '761024', '760824', '761224', '761624', '761629', '761424', '761429', '765024')
 );