[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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
