Re: Problem with count() - URGENT

2001-07-03 Thread Kenneth Kopelson
Just to point out, you did not describe t2 in this email, but you have redescribed t1 again, and not table t2. Also, from looking at your query, I can see the following things: If you did not have the where condition checking for the timestamp, then you would get the entry for "four" since th

Re: Problem with count() - URGENT

2001-07-03 Thread Kenneth Kopelson
Just to point out, you did not describe t2 in this email, but you have redescribed t1 again, and not table t2. Also, from looking at your query, I can see the following things: If you did not have the where condition checking for the timestamp, then you would get the entry for "four" since th

Problem with count() - URGENT

2001-07-03 Thread Ireneusz Piasecki
I have 2 tables: 1) t1 mysql> describe t1; ++-+--+-+-++ | Field | Type| Null | Key | Default | Extra | ++-+--+-+-++ | id | int(3) | | PRI | NULL| auto_increme