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

[Jay Blanchard]

[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)
  )