List:General Discussion« Previous MessageNext Message »
From:Jay Blanchard Date:April 16 2007 1:18pm
Subject:RE: how to tell if something hasn't happened yet
View as plain text  
[snip]
select s.* from store s
  where s.id not in
    (select t.storeid from trans t where t.created=date(now()));
[/snip]

This is close, but it does not exclude previous days. I only want to see
those that have not logged in today.

Thread
how to tell if something hasn't happened yetJay Blanchard14 Apr
  • RE: how to tell if something hasn't happened yetAndrey Dmitriev14 Apr
Re: how to tell if something hasn't happened yetMogens Melander14 Apr
  • RE: how to tell if something hasn't happened yetJay Blanchard16 Apr
    • RE: how to tell if something hasn't happened yet - SOLVEDJay Blanchard16 Apr
RE: how to tell if something hasn't happened yetMogens Melander17 Apr
  • RE: how to tell if something hasn't happened yetMogens Melander17 Apr