选择记录可以，删除记录的语句却写不出来了

[医手]

选择

SELECT * FROM [Department] as ta
where [ParentId]<>'' and 
	not exists (select 1 from [Department] where ta.[ParentId]=[DepartmentId]) 

删除

delete FROM [Department] as ta
where [ParentId]<>'' and 
	not exists (select 1 from [Department] where ta.[ParentId]=[DepartmentId]) 

问题就出在删除语句的as ta上， 有没什么解决的办法?

[水族杰纶]

delete ta from   [Department] ta
where [ParentId]<>'' and 
    not exists (select 1 from [Department] where ta.[ParentId]=[DepartmentId]) 

[医手]

谢谢！太振撼了， 仿佛有点明白了delete的真义...