more mysql help

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

yshaf13
Forum Commoner
Posts: 72
Joined: Mon Apr 03, 2006 7:59 pm

re

Post 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.
Post Reply