Grouping Table Results Dynamicly
Posted: Tue Jun 17, 2003 2:18 pm
I have a table with several fields that need to be displayed per record (there are thousands), the table has a "category" column with "data1" data2" "bob3" "imis4" and a dozen other things, is there a way (sql statement) that would grab each of the GROUP BY and display the CATAGORY name befor eit listed off the people in the catagory... i.e
catagory BOY
- Jim
- Farnk
- Sam
- Wally
category Grl
- Sue
- Beth
category DOG
- Ruger
- Fido
and so on and so forth?
catagory BOY
- Jim
- Farnk
- Sam
- Wally
category Grl
- Sue
- Beth
category DOG
- Ruger
- Fido
and so on and so forth?