RE: how to tell if something hasn't happened yet

[Mogens Melander]

Arg, come on, really.

where t.created <= date(now()));

-- 
Later

Mogens Melander
[phone]
[phone]


On Mon, April 16, 2007 15:18, Jay Blanchard wrote:
> [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.
>
>
> --
> This message has been scanned for viruses and
> dangerous content by OpenProtect(http://www.openprotect.com), and is
> believed to be clean.
>
>



-- 
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.