Page 2 of 2

re

Posted: Thu Jul 27, 2006 3:36 pm
by yshaf13
this is how i ended up doing it - unexpected and simple

"

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 ";
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.