在下面的考勤打卡里，关联了外出和请假，但是查询不到？ if(sql("jiaoxei","select 1 from 外出申请 where '"+(F4+" 10:00:00")+"' between 外出时间 and 回校时间 and 姓名='"+D4+"'",1,1)=1,"外出",nvl(SQL("jiaoxei","select 请假类型 from 请假申请 where '"+(F4+" 10:00:00")+"' between 起始时间 and 销假时间 and 请假人='"+D4+"'",1,1),if(len(G4) = 0, "缺卡", IF(G4 <= "07:37:59", "正常", "迟到"))))
|
1min目标场景问卷
立即参与
