On 04/12/2018 09:11 AM, Alexander Barkov wrote: <cut> >> >>> >>> Anyway you can't use anymore: >>> SELECT c FROM t1 ORDER BY a >>> UNION >>> SELECT c FROM t2 ORDER BY b >>> ORDER BY c. >>> >>> You have to put it so: >>> (SELECT c FROM t1 ORDER BY a) >>> UNION >>> (SELECT c FROM t2 ORDER BY b) >>> ORDER BY c. >>> >>> (see the standard). >> >> I like this change.
Sorry, I misread the query. This was not actually not possible in 10.3: SELECT c FROM t1 ORDER BY a UNION SELECT c FROM t2 ORDER BY b ORDER BY c; >> <cut> _______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp