Hi there,

I wonder if someone can help me. I have 3 columns in my table - DATE,
DOCUMENT, and SUBDOCUMENT. Each document has 4 different sub-documents.
Is there a MySQL query that will allow me to get all the information
from this table ordered by Document (alphabetically), and then by
subdocument listing design, code, inspection, and test in that order?

E.g.

DATE DOCUMENT SUBDOCUMENT
Jul 31st test1 design
Jul 31st test1 code
Jul 31st test1 inspection
Jul 31st test1 test
Jul 31st test2 design
Jul 31st test2 code
Jul 31st test2 inspection
Jul 31st test2 test
^ ^


Thanks in advance for any replies!

- Best regards,

Leigh

create a SubdocumentOrder table:

create table SubdocumentOrder(SortSeq int, SubDocument char(64));

insert into SubdocumentOrder values(1, 'design');
insert into SubdocumentOrder values(2, 'code');
insert into SubdocumentOrder values(3, 'inspection');
insert into SubdocumentOrder values(4, 'test');

Then join it with the main table, with one of the sort keys being SortSeq.