SQL语句有错误吧

[kingsjava]

目前我有两个表,userinfotable表中有u_addtime时间字段,在排序出来时,尽然把全部的数据都显示出来了,而我只是想显示两条记录,是否SQL语句有错误?用的是ACCESS表.
xx_sqlus="select top 2 * from userinfotable,worktimetable where userinfotable.id=cint(worktimetable.uid) and userinfotable.ufu='已安排' order by cdate(userinfotable.u_addtime) desc"

[jhwcd]

xx_sqlus="select top 2 * from userinfotable,worktimetable where userinfotable.id=worktimetable.uid and userinfotable.ufu='已安排' order by  userinfotable.u_addtime desc"

[tjficcbw]

select top 2 * from userinfotable,worktimetable where userinfotable.id=worktimetable.uid and userinfotable.ufu='已安排' order by  userinfotable.u_addtime desc