UPDATE，DELETE多表操作

 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 ' ;