Paul, do you address this in any of your books?

2003-03-14 Thread DANIEL GADDIS
I'm running MySql 4.0.10-gamma-max-nt-log I have 1 table like the one below... ++-+--+ | DAY| USERID | LIS_QUANTITY | ++-+--+ | 2003-01-02 | H0850A1 | 539 | | 2003-01-02 | LBBSWJR |7 | | 2003-01-02 |

Re: Paul, do you address this in any of your books?

2003-03-14 Thread Gelu Gogancea
: Paul, do you address this in any of your books? I'm running MySql 4.0.10-gamma-max-nt-log I have 1 table like the one below... ++-+--+ | DAY| USERID | LIS_QUANTITY | ++-+--+ | 2003-01-02 | H0850A1 | 539 | | 2003-01

Re: Paul, do you address this in any of your books?

2003-03-14 Thread Gelu Gogancea
: Re: Paul, do you address this in any of your books? Hi, You can try to use IF(),CASE() function in the SQL statement. Eg. select USERID,IF(DAY='2003-01-02',COUNT(*),0) as 2003-01-02,IF(DAY='2003-01-03',COUNT(*),0) as 2003-01-03...how_many_days_you_wishfrom YOUR_TABLES where

Re: Paul, do you address this in any of your books?

2003-03-14 Thread Paul DuBois
At 14:40 -0600 3/14/03, DANIEL GADDIS wrote: I'm running MySql 4.0.10-gamma-max-nt-log I have 1 table like the one below... ++-+--+ | DAY| USERID | LIS_QUANTITY | ++-+--+ | 2003-01-02 | H0850A1 | 539 | | 2003-01-02

Re: Paul, do you address this in any of your books?

2003-03-14 Thread rich allen
this article on cross tabulations should help you ... http://www.mysql.com/articles/wizard/index.html - hcir (mysql sql query) On Friday, Mar 14, 2003, at 11:40 America/Anchorage, DANIEL GADDIS wrote: I'm running MySql 4.0.10-gamma-max-nt-log I have 1 table like the one below...