From: Mogens Melander
Date: April 17 2007 8:14am
Subject: RE: how to tell if something hasn't happened yet
List-Archive: http://lists.mysql.com/mysql/206202
Message-Id: <1273.90.184.17.152.1176797654.squirrel@mail.fumlersoft.dk>
MIME-Version: 1.0
Content-Type: text/plain;charset=utf-8
Content-Transfer-Encoding: 8bit

Argh, that was not the one i wanted to send :)

This is the one:

select s.* from store s
   where s.id not in
     (select t.storeid from trans t
        where t.created > date(now()) - interval 1 day);

-- 
Later

Mogens Melander
+45 40 85 71 38
+66 870 133 224


On Tue, April 17, 2007 09:20, Mogens Melander wrote:
> Arg, come on, really.
>
> where t.created <= date(now()));
>
> --
> Later
>
> Mogens Melander
> +45 40 85 71 38
> +66 870 133 224
>
>
> 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.
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=mogens@stripped
>



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