SELECT * FROM COMPETITION_RESULTS_1500MFS ORDER BY MESTO ASC UNION SELECT * FROM COMPETITION_RESULTS_800MFS ORDER BY MESTO ASC UNION SELECT * FROM COMPETITION_RESULTS_50MFS ORDER BY MESTO ASC
  • @ d1mex; To format a code, select it with the mouse and click on the {} button of the editor. - Nicolas Chabanovsky ♦

1 answer 1

When merging multiple queries through UNION, the collation is set after the last query.

 SELECT * FROM COMPETITION_RESULTS_800MFS UNION SELECT * FROM COMPETITION_RESULTS_50MFS ORDER BY MESTO ASC