使用左连接和表变量进行删除

Question

也许我缺少括号或其他东西，但我很难从表变量中删除行，我在其中加入并寻找要加入的键。 如果它有价值，那么我就会摆脱它。 问题是我无法解析查询。 有任何想法吗？

declare @MrTemp 
(
    key1 int
   ,key2 int
)

insert into @MrTemp
select key1, key2 from ASourceTable

delete  
from @MrTemp mt
left join ARealTable art on mt.key1 = art.key1 and mt.key2 = art.key2 
where art.key1 is not null and art.key2 is not null

Answer 1

DELETE @MrTemp
FROM @MrTemp mt LEFT JOIN ...

Answer 2

您需要在删除之后但在要从中删除的表的 from 之前引用别名

delete art 
from @MrTemp mt left join ARealTable art on 
mt.key1 = art.key1 and mt.key2 = art.key2 
where art.key1 is not null and art.key2 is not null

Answer 3

您一次只能从一个表中删除：

从 @MrTemp [ARealTable 中有匹配记录]

delete mt
from @MrTemp mt left join ARealTable art on mt.key1 = art.key1 and mt.key2 = art.key2 where art.key1 is not null and art.key2 is not nu

ll

或删除。
从 ARealTable 中删除 [同样，该记录在 ARealTable 中有对应的记录]

delete art
from @MrTemp mt left join ARealTable art on mt.key1 = art.key1 and mt.key2 = art.key2 where art.key1 is not null and art.key2 is not null