Posted by Frank on 12/05/05 03:54

I have a table with the following structure:

main_category| category| sub_category| answer|date

Basically, the data will be along these lines:

Neuro | LOC | Status | answer1|date
Neuro | LOC | Status | answer2|date
Neuro | LOC | Status | answer3|date
Senso| Visi | Clarity | answer1|date
Senso| Visi | Clarity | answer2|date
etc...
I am trying to query the db and present the user with the data in the
following structure:

Main Category
Category
Sub Category
answer1
answer2
answer3
...

Main Category
Category
Etc...

There are literally 3 dozen main categories, categories, and
sub-categories each with distinct answers.
I could really use some help on a query to group the data in this way!

Thanks in advance!!!


Frank

[Back to original message]