-- 赋值新增字段foutputdatatype
update t_fah_dynextfld_valset as tv set foutputdatatype = (select te.foutputdatatype foutputdatatype from t_fah_dyn_extfld as te where tv.fdynextfldid=te.fid)
where tv.fdynextfldid <> 0 and exists (select 1 from t_fah_dyn_extfld as te2 where tv.fdynextfldid = te2.fid);
-- 赋值新增字段frefbaseprop 固定取值方式的基础资料类型数据（辅助资料类型还没有数据，无需处理）
update t_fah_dynextfld_valset as tv set frefbaseprop = (select te.fbaseprop fbaseprop from t_fah_dyn_extfld as te where tv.fdynextfldid=te.fid )
where tv.fdynextfldid <> 0 and tv.fgetvaluetype ='0' and tv.foutputdatatype='1' and exists (select 1 from t_fah_dyn_extfld as te2 where tv.fdynextfldid = te2.fid);