mysql: выборка из двух таблиц с сортировкой по определенному полю
(SELECT id,name FROM city WHERE ifcap='1') UNION (SELECT id,name FROM region) ORDER BY name;
(SELECT id,name FROM city WHERE ifcap='1') UNION (SELECT id,name FROM region) ORDER BY name;