access这样写
SELECT DEPTNAME AS 部门,NAME AS 姓名,BADGENUMBER AS 考勤号,CHECKTIME AS 考勤时间,CHECKTYPE AS '签到/退',SENSORID AS 机器号 FROM USERINFO,CHECKINOUT,DEPARTMENTS WHERE CHECKINOUT.USERID = USERINFO.USERID AND DEPARTMENTS.DEPTID=USERINFO.DEFAULTDEPTID AND USERINFO.NAME = '陈汉耿' AND CHECKINOUT.CHECKTIME BETWEEN #2003-12-17 15:30:00# AND #2003-12-30 15:30:00# ORDER BY CHECKINOUT.USERID,CHECKINOUT.CHECKTIME ASC
SELECT DEPTNAME AS 部门,NAME AS 姓名,BADGENUMBER AS 考勤号,CHECKTIME AS 考勤时间,CHECKTYPE AS '签到/退',SENSORID AS 机器号 FROM USERINFO,CHECKINOUT,DEPARTMENTS WHERE CHECKINOUT.USERID = USERINFO.USERID AND DEPARTMENTS.DEPTID=USERINFO.DEFAULTDEPTID AND USERINFO.NAME = '陈汉耿' AND CHECKINOUT.CHECKTIME BETWEEN #2003-12-17 15:30:00# AND #2003-12-30 15:30:00# ORDER BY CHECKINOUT.USERID,CHECKINOUT.CHECKTIME ASC
解决方案 »
- 如何在sql语句中,为某个字段赋空值?
- 求数据库方案
- access中好像没有ifnull函数?
- 怎样用T-SQL来打开文件并显示出来?
- 麻烦高手帮我看看这个存储过程有什么问题,为什么运行时会出现资源不足
- 数据库的还原
- 向 邹老大,all,dawugui,小梁子......求组--关于window2003服务器上的sql2000数据库端口被限制问题?只能本机访问,如何在服务器上设置成别的ip地址的机器也可以访问啊,
- 用游标更新表,速度异常慢
- 关于两个日期间
- 请问在sql server2000中怎么对存储过程进行加密和解密?
- 建视图里要给一个字符型字段赋常量,如何做?sqlserver的数据库。
- 这个查询语句怎么写
SELECT DEPTNAME AS 部门,NAME AS 姓名,BADGENUMBER AS 考勤号,CHECKTIME AS 考勤时间,CHECKTYPE AS '签到/退',SENSORID AS 机器号 FROM USERINFO,CHECKINOUT,DEPARTMENTS WHERE CHECKINOUT.USERID = USERINFO.USERID AND DEPARTMENTS.DEPTID=USERINFO.DEFAULTDEPTID AND USERINFO.NAME = '陈汉耿' AND CHECKINOUT.CHECKTIME BETWEEN #2003-12-17 15:30:00# AND #2003-12-30 15:30:00#
and weekday(CHECKINOUT.CHECKTIME) between 2 and 6 ORDER BY CHECKINOUT.USERID,CHECKINOUT.CHECKTIME ASC