update b
set memo = a.name
from a,b
where a.id = b.id
-------------------------------------------------------
删除两个表中的数据
delete employee, employeeSkills
from employee, employeeSkills, department
where employee.employeeID = employeeSkills.employeeID
and employee.departmentID = department.departmentID
and department.name = ' Finance ' ;