I know how to
write it.
Let me know how it works:
select u.username Who, ifnull(count(d.username),0) Logs
from users as u left join details as d
on u.username = d.username
and d.entrydate > date_add(now(), interval -7 day )
where u.disabled='N'
group by u.username
order by 2 desc
Hi
I posted the question below a little over a week ago and I have not had any
responses. Can anyone let me know if my email lacked detail and that's why
I've had no responses or whether this is a bug? I can create a complete
script that creates the tables, populates them and runs the querries
