SQL с Union and order - Printable Version +- CodeIgniter Forums (https://forum.codeigniter.com) +-- Forum: CodeIgniter 4 (https://forum.codeigniter.com/forumdisplay.php?fid=28) +--- Forum: CodeIgniter 4 Support (https://forum.codeigniter.com/forumdisplay.php?fid=30) +--- Thread: SQL с Union and order (/showthread.php?tid=84949)

SQL с Union and order - motoroller - 11-27-2022 I have 2 queries than i Union, but how can i order united data? not each, i need order total result SELECT *( SELECT CONCAT(firstName,' ',lastName) fullname FROM employees UNION SELECT CONCAT(contactFirstName,' ',contactLastName) FROM customers) as grouped ORDER BY `grouped`.`ordering` DESC, `grouped`.`date` DESC, `grouped`.`name` LIMIT 15 I need something like this one