 加好友  发短信
等级：八尾狐
帖子：1953
积分：15015
威望：0
精华：0
注册：2016/4/28 9:58:00
|
left join查询  Post By：2024/5/30 13:05:00 [显示全部帖子]
tb1.Fill("Sel ect camera_rec_record.id_number as 编号, camera_rec_record.person_name as 姓名,学生信息.班级,camera_rec_record.match_date as 日期,camera_rec_record.match_time As 时间,camera_rec_record.id From {camera_rec_record} left join 学生信息 on camera_rec_record.id_number ={学生信息}.身份证件号 and camera_rec_record.match_time >= '" & Date.Today & " 00:00:00' and camera_rec_record.match_time<= '" & Date.Today & " 23:59:59'order by match_time desc","user",True)
请问老师上面句子不行，查出的是所有记录，不是当天
|
|
