re
Posted: Thu Jul 27, 2006 3:36 pm
this is how i ended up doing it - unexpected and simple
"
theoretically it should sort the first select by the primary column
and the second select by the column i specified but it actually sorts the entire resultset.
thank you all for your help.
"
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.