Back to update on progress.. was able to do what I needed by sticking it all into temp table.. gotta do each field at once
mysql> update tmp1_details as t1 inner join mwiz.mw_list_field_value as fv on t1.subscriber_id=fv.subscriber_id set t1.first_name=value where fv.field_id=222;