Changing the default sql SELECT view?

[JSours]

When logging in, Xataface displays my tables in a default order. I specifically want to change the SQLquery so it displays it how I want it. Where would I go to do this?

[shannah]

Xataface uses the -sort parameter for choosing how to sort tables. To set the default sort, see this thread for a hint:
viewtopic.php?f=4&t=5927

Although if you want a solution to work for multiple tables you'll need to take that into account. The example in that thread doesn't specify the table you are sorting for.