Hell all. I would greatly appreciate any info you folks could offer...
I am trying to sort a table that has three different index fields and I can't get the records in the correct order. I have tried several variations of the ORDER BY clause, but I haven't made it work.
The query that seems to give me the best results is...
SELECT * FROM glossary ORDER BY primary_index, secondary_index, tertiary_index;
Now, I'd like to get the records to display in sequential order from top to bottom, but obviously they are displaying as only somewhat sequential. Anybody got an idea? or am I just hopeless? Thanks!
-Bradley
BTW - The reason for the three indexes is because there are a few different relationships between the records.
