[snip]
[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.
[/snip]
select store.storeid, store.stname
from store
where store.storeid not in (
select transaction.storeid
from transaction
where substring(transaction.created, 1, 10) >
date_sub(current_date(),
interval 1 day)
)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
