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/[EMAIL PROTECTED]
