> mysql> select sum(trial_signups) from campaign_t where > datestamp='20021204'\g > +--------------------+ > | sum(trial_signups) | > +--------------------+ > | 100 | > +--------------------+ > > > mysql> SELECT site_id, sum(raws) As RawHits, sum(uniques) As > UniqueHits, > sum(trial_signups) As Sales FROM campaign_t WHERE datestamp >= > '20021204' AND datestamp <= '20021204' GROUP BY site_id\g > +---------+---------+------------+-------+ > | site_id | RawHits | UniqueHits | Sales | > +---------+---------+------------+-------+ > | 1 | 6231 | 3672 | 1 | > | 2 | 143 | 96 | 0 | > | 3 | 256 | 128 | 0 | > | 4 | 16 | 11 | 0 | > | 6 | 9 | 9 | 0 | > | 7 | 88 | 45 | 2 | > | 8 | 1801 | 1055 | 11 | > | 9 | 2805 | 1979 | 2 | > | 10 | 2251 | 669 | 0 | > +---------+---------+------------+-------+ > > It's JUST the date '20021204'.. the rest of the dates (for the past 4 > months) have been working fine. > > Any ideas?
Only one: Are there any NULL values in the site_id column for that date? --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php