求句SQL嵌套删除语句

Question

delete from checkyear a
where exists(select 1 from year where name = a.dwmc)

Answer 1

DELETE FROM checkyear表
WHERE checkyear表.dwmc=year表.name 
不会是这样吧
期待高手

Answer 2

delete checkyear from [year] where dwmc=[name]

Answer 3

delete checkyear
from checkyear,[year]
where checkyear.dwmc=[year].name

Answer 4

delete from checkyear b where exists (select 1 from year name =b.dwmc)

Answer 5

delete checkyear where dwmc in(select name from year)
--ordelete checkyear a where exists(select 1 from year where name = a.dwmc)

Answer 6

delete tp from checkyear tp where exists(select 1 from year where name=a.dwmc)