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, Mog
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()));
> [/sn
[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
[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.
How about this:
select s.* from store s
where s.id not in
(select t.storeid from trans t where t.created=date(now()));
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
On Sat, April 14, 2007 00:22, Jay Blanchard wrote:
> Good day gurus and gurettes!
>
> I have a table;
>
> | tr
It depends on what's in the datetime column.
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
Something like this:
select store.storeid, store.stName
from store left outer join transaction
on(store.storeid = transaction.storeid)
where transaction.created IS NULL
and store.ac
