参考页面:https://www.cnblogs.com/mybi/archive/2012/05/20/2510710.html
1 UPDATE Lab_Test_Master 2 SET Lab_Test_Master.id_number= Applied_Patient_Info.Identity_No, 3 Lab_Test_Master.Telephone = Applied_Patient_Info.Tel 4 FROM 5 Applied_Patient_Info 6 WHERE 7 Lab_Test_Master.YW_Test_No= Applied_Patient_Info.YW_Test_No