update  opl_ILL_in l inner join opl_item i on i.barcode=l.local_bc inner join opl_marcRecord m using(rid) set m.tempIll='ILL'  where m.tempIll is null;
