search

erdomke / InnovatorAdmin

A tool for managing Aras Innovator installations focusing on improving the import/export experience.
http://erdomke.github.io/InnovatorAdmin/
MIT License
58 stars 42 forks source link

Inconsistent order of columns returned #172

Open rneuber1 opened 8 years ago

rneuber1 commented 8 years ago

If you issue the same SQL query with ApplySQL on two databases, the order of columns returned is different:

image

rneuber1 commented 8 years ago

This is the query I used:

<sql>select U.id,U.login_name, U.first_name,U.last_name, U.email, M.login_name, U.logon_enabled,U.last_login_date from innovator.[User] as U inner join innovator.[User] as M on U.manager=M.id order by U.last_name</sql>