View Single Post
  #3 (permalink)  
Old 07-03-2008, 09:16 AM
Unregistered
 
Posts: n/a
Default 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
Reply With Quote