求一条SQL命令的优化

SQL code:
SELECT cCardNo, MAX(dtime)AS dtime,cDoorId,cReadId,cStatus
from Attend_Record
WHERE cDoorID IN (SELECT distinct cDoorID from Attend_Doorinfo WHERE isApplyWork = 1)
GROUP BY cCardNo,cDoorId,cReadId,cStatus


输出结果：
卡号　　　时间　　　　　　　　　　　门　　　　进出　　　状态
18625006 2010-01-20 08:15:28.000 M0001-1 2 通过
18624907 2010-01-19 18:13:43.000 M0002-1 2 通过
18625119 2010-01-20 08:04:22.000 M0002-1 1 通过
05520234 2010-01-08 18:50:49.000 M0001-1 1 通过
18618170 2009-10-18 07:56:38.000 M0001-1 2 未通过
18564167 2010-01-19 18:16:02.000 M0002-1 2 通过
18609273 2010-01-20 08:05:10.000 M0002-1 1 通过
18619763 2010-01-19 14:07:44.000 M0001-1 2 通过
18602260 2009-09-28 12:36:18.000 M0001-1 2 未通过
18624356 2010-01-19 10:49:51.000 M0002-1 1 通过

如果库内的记录里，同一张卡，在同一个门刷了进出二次的话，这条命令查出来的是二条记录
而我想要的记录结果是，一张卡在一个门内只查寻最后一条记录，无论是进还是出
求优化

---

SQL code:
SELECT cCardNo, MAX(dtime)AS dtime,cDoorId,cReadId,cStatus
from Attend_Record as a
WHERE exists(SELECT cDoorID from Attend_Doorinfo WHERE isApplyW