select c.*,d.*
from (
select distinct date(sign_in_time) sign_date,b.id,b.name
from sign_on_log a , users b
where b.status=0
) c left outer join sign_on_log d on c.sign_date=date(d.sign_in_time) and c.id=d.user_id
order by sign_date desc,name
from (
select distinct date(sign_in_time) sign_date,b.id,b.name
from sign_on_log a , users b
where b.status=0
) c left outer join sign_on_log d on c.sign_date=date(d.sign_in_time) and c.id=d.user_id
order by sign_date desc,name
扫一扫
31万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
