update opl_item i inner join opl_itemInfo f using(barcode) set i.typeId=f.sf852Data where i.typeId='' && f.sf852Code='3'; update opl_item i inner join opl_itemInfo f using(barcode) set i.location=f.sf852Data where i.location='' && f.sf852Code='c';
