select 字段1,字段2,... from tableName1 a INNER JOIN (select 字段1,字段2,... from tableName2) b ON a.×× = b.×× and a.×× = '';
UPDATE tableName1 a INNER JOIN (select 字段1,字段2,... from tableName2) b ON a.×× = b.×× and a.×× = '' SET a.字段1 = b.字段2;
select 字段1,字段2,... from tableName1 a INNER JOIN (select 字段1,字段2,... from tableName2) b ON a.×× = b.×× and a.×× = '';
UPDATE tableName1 a INNER JOIN (select 字段1,字段2,... from tableName2) b ON a.×× = b.×× and a.×× = '' SET a.字段1 = b.字段2;