ANY answer.
Re: Complicated sorting in one sql
no, i cant use ORDER BY because the results are not ordered
by Id or by Test.
They are grouped (for display) by Test but ordered by Id.
i.e.:
Test "B" willl apear first because it has the smallest Id. Since the
results are grouped by Test all the rest of the B's will appear directly after it.
Then the groupd of Test "A", and last the group of Test "C"
10x,
Alex
|