update多表查询

 在set中可以用多表标识

update一次只能更新一个表

UPDATE table1 t1 SET t1.managerid = 
(SELECT aid FROM 
	(
		SELECT a.id AS aid,a.lastname AS alastname,a.managerid AS amanagerid,b.id AS bid,b.lastname AS blastname,b.managerid AS bmanagerid
		FROM table2 a,table2 b WHERE a.fax = b.certificatenum 
	) AS t2 
WHERE t1.id  = t2.bid
)
WHERE t1.id = 2749