I have a list box and I want to order data in multiple columns.
I used the ORDER BY statement, but I just can order one column at once. I would like to order one column, let's say 1, 2, 3.. and then I would like to order another column, by some random naming like aaa, bbb, ccc (but not in alphabetical order) so it looks like this:
1 aaa
1 aaa
1 bbb
1 ccc
2 aaa
2 bbb
2 bbb
3 aaa
What does the code look like, or the ORDER BY statement?