使用内部联接从表中删除

本文介绍了使用内部联接从表中删除的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我试图通过将其与另一个表tasktype连接来删除名为tasks的表中的内容。但是在尝试删除时出现错误。 它说INNER附近的语法不正确。 这是我试过的。

DELETE FROM 任务t INNER JOIN tasktype tt ON t.tasktypeID = tt.tasktypeID WHERE tt.tasktypename = ' Ad-hoc'

谢谢。

解决方案

试试这个：

DELETE FROM t FROM 任务t INNER JOIN tasktype tt ON t.tasktypeID = t t.tasktypeID WHERE tt.tasktypename = ' 特设'

Hi, I am trying to delete contents from table named "tasks" by joining it with another table "tasktype". But am getting an error when trying to delete. It says incorrect syntax near INNER. Here is what i have tried.

DELETE FROM tasks t INNER JOIN tasktype tt ON t.tasktypeID = tt.tasktypeID WHERE tt.tasktypename = 'Ad-hoc'

Thank you.

解决方案

Try this:

DELETE FROM t FROM tasks t INNER JOIN tasktype tt ON t.tasktypeID = tt.tasktypeID WHERE tt.tasktypename = 'Ad-hoc'