比如一共有Luis,Bob2个用户, User表里内容为 user date effort Luis 20061019 1 Luis 20061018 8 Luis 20061017 4 Luis 20061016 6 Bob 20061017 5现在要找出一周内哪些人哪些天没有填写记录。 结果应该这样: Luis 20061015 Luis 20061014 Luis 20061013 Bob 20061019 Bob 20061018 Bob 20061016 Bob 20061015 Bob 20061014 Bob 20061013
select user,date from billing,user where billing.user=user.user and date(now())-billing.date<7;
User表里内容为
user date effort
Luis 20061019 1
Luis 20061018 8
Luis 20061017 4
Luis 20061016 6
Bob 20061017 5现在要找出一周内哪些人哪些天没有填写记录。
结果应该这样:
Luis 20061015
Luis 20061014
Luis 20061013
Bob 20061019
Bob 20061018
Bob 20061016
Bob 20061015
Bob 20061014
Bob 20061013
from billing,user
where billing.user=user.user and date(now())-billing.date<7;