转载:https://blog.csdn.net/u013795102/article/details/107831544
DELETE JOIN with JOIN(联表删除数据)
DELETE T1[, T2]
FROM T1
INNER JOIN T2 ON T1.key = T2.key
WHERE condition;
例
DELETE employee , department
FROM employee
INNER JOIN department ON employee.did = department.ids
WHERE employee.did = 126 ;
多表关联插入
多表关联