删除的sql查询

Question

delete  a.Employee_LastName, a.Employee_Firstname 
FROM    EMPLOYEE a JOIN DEPARTMENT b on a.Department_ID = b.Department_ID 
where b.Department_Name='Sales' 
Group by a.Employee_LastName, a.Employee_Firstname, b.Department_Name

你能解释一下我做错了什么吗？错误(在 sql server 2008 中):消息 102，级别 15，状态 1，第 1 行“,”附近的语法不正确。

Answer 1

Delete 用于删除整行..而不是清空字段(因此不支持列名，也没有分组)

所以

DELETE EMPLOYEE
FROM   EMPLOYEE a JOIN DEPARTMENT b ON a.Department_ID = b.Department_ID 
WHERE  b.Department_Name = 'Sales' 

---

如果你想编辑记录然后我们 UPDATE