"
Code: Select all
SELECT id, date, title, short_desc
FROM cgi_admin
UNION SELECT id, date, title, short_desc
FROM cgi_activities
ORDER BY `title` ASC ";and the second select by the column i specified but it actually sorts the entire resultset.
thank you all for your help.