select kq_user.num,kq_user.name,kq_day.day_time,kq_day.arrival_time,kq_user.deptName from kq_user left join kq_day on kq_user.num=kq_day.userid where kq_day.day_time>='20101001' and kq_day.day_time<='20101031' and kq_user.deptno!=8 group by kq_user.num order by arrival_time asc ; 其他的条件是否不满足?
查下kq_day里day_time为20101013的数据的deptno; select distinct deptno from kq_day where day_time='20101013'
select kq_user.num,kq_user.name,kq_day.day_time,kq_day.arrival_time,kq_user.deptName from kq_da left join kq_user on kq_user.num=kq_day.userid where kq_day.day_time>='20101001' and kq_day.day_time<='20101031' and kq_user.deptno!=8 group by kq_user.num order by arrival_time asc
select kq_user.num,kq_user.name,kq_day.day_time,kq_day.arrival_time,kq_user.deptName
from kq_user left join kq_day on kq_user.num=kq_day.userid
where kq_day.day_time>='20101001' and kq_day.day_time<='20101031' and kq_user.deptno!=8 group by kq_user.num order by arrival_time asc ;
其他的条件是否不满足?
select distinct deptno from kq_day where day_time='20101013'
问题不应该出在这张表吧
select kq_user.num,kq_user.name,kq_day.day_time,kq_day.arrival_time,kq_user.deptName
from kq_da left join kq_user on kq_user.num=kq_day.userid
where kq_day.day_time>='20101001' and kq_day.day_time<='20101031' and kq_user.deptno!=8 group by kq_user.num order by arrival_time asc