数据表table1 --》 字段 name ,age,def,org_code,del_flag ,id
数据表table2 code, table1_id, own,del_flag
代码如下
update table2 b
left join (
select distinct name ,org_code,batch_no from table1 where del_flag = 0
) a on a.id= b.table1_id
set b.code= a.name ,b.own= a.org_code
where b.del_flag = 0 and (b.codeis null or b.ownis null);
本人拙见 -----仅供参考!