SQL DELETE JOIN语句

这是很常见的问题是如何利用连接语句更新行或删除

这不是一个很容易的过程中，有时，我们需要更新或删除记录复杂的WHERE子句的基础上。

还有我们用它来对SQL语法DELETE操作JOIN三个表。

这些表是表1，表2和目标表。

SQL语法删除JOIN

DELETE [target table]
FROM    [table1]
        INNER JOIN [table2]
ON [table1.[joining column] = [table2].[joining column]
WHERE   [condition]

语法更新

UPDATE [target table]
SET [target column] = [new value]
FROM    [table1]
        INNER JOIN [table2]
ON [table1.[joining column] = [table2].[joining column]
WHERE   [condition]