关键使用表

select *  from ORG_MEMBER where name='张三'   --8733801825363773380


select *  from ATTENDANCE_INFO where OWNER_ID=8733801825363773380 order by SIGN_TIME desc  --打卡时间
select *  from ATTENDANCE_DAY_STATISTICS where MEMBER_ID=8733801825363773380 order by PUNCH_DATE desc 

 

posted @ 2022-10-01 14:12  菜菜程序猿  阅读(95)  评论(0编辑  收藏  举报