My relational data is stored in a MySQL version 4, which doens't support subqueries.

I want to display my relational data in a table which includes columns that has really tricky queries.

If I could have used subqueries, I would only have to use one query for the entire table data.

I have solved the problem by using different recordsets, and displaying for an example the first three columns from one recordset, next two from another recordset and the last column from the third recordset.

The table is always rectangular and could look like this:

| Id | Name | Genre | Number of articles | Total number of replies | Mean article length |

Now to the Question:

How can I sort this table on each column? Say I sort by Name ASC, could I use the ID column to sort the "Number of articles" column?