>Well, I thought I could generalize my problem to a simple example. But this example does work as is. But I'm 100% sure that my more complex query doesn't work. In the table desinger the order is as written in the query, but visually it isn't.

Do you by "visually" mean "I click the browse button in the Data Session window"? That issues a "browse last" command, and the layout is as it was last saved in your resource file. Try typing "browse" in your command window, without the "last" clause. That should get rid of the last saved layout.