mysql 多表更新

更新表1的某一列为表2中与表一关联的那些行的某列最大值

SET SQL_SAFE_UPDATES = 0;
UPDATE  schema.tb1 name1
 
SET name1.law1= (
SELECT name2.law2 FROM tb2 name2 
WHERE name2.law2 = name1.law1 ORDER BY name2.law2 DESC limit 1
)

WHERE name1.law between '2010-01-01 00:00:00' and '2010-01-01 24:00:00' ;