使用内部联接从表中删除 [英] Delete from table using inner join

问题描述

我试图通过将其与另一个表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'

这篇关于使用内部联接从表中删除的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！