select name,CHECKTIME from USERINFO,CHECKINOUT where USERINFO.USERID = CHECKINOUT.USERID and CHECKTIME between '2018-11-30' and '2019-1-1' order by name asc ,CHECKTIME asc
考勤sql语句
最新推荐文章于 2022-04-13 18:38:12 发布
select name,CHECKTIME from USERINFO,CHECKINOUT where USERINFO.USERID = CHECKINOUT.USERID and CHECKTIME between '2018-11-30' and '2019-1-1' order by name asc ,CHECKTIME asc