SQL с Union and order |
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 |
Messages In This Thread |
SQL с Union and order - by motoroller - 11-27-2022, 07:10 AM
|