sql - 带左连接的输出子句，如何？

Question

是否可以按照这些思路做一些事情:

DELETE TOP(1) m
FROM MyTable m
OUTPUT deleted.*
LEFT JOIN MyOtherTable ON MyOtherTable.SomeColumn=s.SomeColumn

我知道这有效:

DELETE TOP(1) 
FROM MyTable
OUTPUT deleted.*

这也有效(尽管毫无意义):

DELETE TOP(1) m 
FROM MyTable m
LEFT JOIN MyOtherTable ON m.SomeColumn=MyOtherTable.SomeColumn

Answer 1

将 OUTPUT 子句移至 JOIN 之前

DELETE TOP(1) m 
OUTPUT deleted.* 
FROM MyTable m 
LEFT JOIN MyOtherTable ON MyOtherTable.SomeColumn=s.SomeColumn