ORDER BY

There only seems to be a secondary order available, to display my tables correctly I will need four. Is it possible to add more order conditions?

regards,
Robert

Hi,

you can always create view that will have as many order by's as you wish.

CREATE VIEW MyView AS
SELECT column1, column2, column3, column4
FROM YourTable
ORDER BY column4, column2, column1, column3