self join

>I have many queries that return results like this:
>
>Name    Month    Count
>Fred    Jan    50
>Wilma    Jan    32
>Barney    Jan    33
>Betty    Jan    30
>Fred    Feb    60
>Wilma    Feb    42
>Barney    Feb    43
>Betty    Feb    40
>Fred    Mar    40
>Wilma    Mar    22
>Barney    Mar    23
>Betty    Mar    20
>
>etc...
>
>I often need to convert that into a table or array that looks like this:
>
>Name    Jan    Feb    Mar
>Fred    50    60    40
>Wilma    32    42    22
>Barney    33    43    23
>Betty    30    40    20
>
>What is the simplest/fastest way to do that conversion?
>
>Dave Machin
>
>
>E-Mail. [EMAIL PROTECTED]
>Tel.  805.614.0123 x 30
>Address: 3130 Skyway Drive #702
>Santa Maria, CA 93455
>
>________________________________________________________________________
>TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
>


Bill Conlon

To the Point
345 California Avenue Suite 2
Palo Alto, CA 94306

office: 650.327.2175
fax:    650.329.8335
mobile: 650.906.9929
e-mail: mailto:[EMAIL PROTECTED]
web:    http://www.tothept.com


________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf

Reply via email to