这条语句报语法错误，看不明白，请指教

[寒寒]

select * from kq_OrderRepast k where
(k.employeeid,k.orderdate,k.repasttype) in
(select employeeid,orderdate,repasttype from kq_OrderRepast group by employeeid,orderdate,repasttype having count(*) >1)

这是一条查询三个字段时同时重复的语句，但是在执行的时候，SQL SERVER提示：

服务器: 消息 170，级别 15，状态 1，行 2
第 2 行: ',' 附近有语法错误。

请指教这样写为什么不可以，请说明原因。

[快溜]

select * from kq_OrderRepast k where  
checksum(k.employeeid,k.orderdate,k.repasttype) in  
(select checksum(employeeid,orderdate,repasttype) from kq_OrderRepast group by employeeid,orderdate,repasttype having count(*) >1)

[Xiao_Ai_Mei]

select employeeid,orderdate,repasttype 
from kq_OrderRepast k 
group by employeeid, orderdate,repasttype 
having count(*) >1 

in只能判断一个字段

[xuam]

select * from kq_OrderRepast k where
exsits
(select employeeid,orderdate,repasttype from kq_OrderRepast group by employeeid,orderdate,repasttype having count(*) >1)

[寒寒]

[Quote=引用 1 楼 ssp2009 的回复:]
SQL code
select * from kq_OrderRepast k where
checksum(k.employeeid,k.orderdate,k.repasttype) in
(select checksum(employeeid,orderdate,repasttype) from kq_OrderRepast group by employeeid,orderd……
[/Quote]

谢谢，原来多字段的查询，要校验结果集。。
等结案的时候，分都给你