using UNION(table1, table2) I noticed that if columns are not on the same order ... it is a problem, bacause union mixes values of columns with the same name but in a different order.
Is there a way to change the columns' order in a table? It seems it is fixed.
Thanks a lot!
Solved! Go to Solution.
Have you played with the "Sort by Column" feature?
Proud to be a Datanaut!