[thelist] Q on SQL 'ORDER BY'

Richard Harb rharb at earthling.net
Fri Apr 9 18:54:31 CDT 2004

Try ORDER BY jobs.job_title, jobs.job_posted

@see http://dev.mysql.com/doc/mysql/en/SELECT.html

Saturday, April 10, 2004, 1:35:24 AM, you wrote:

> This is what I have....

>   SELECT jobs.job_id, jobs.job_title, jobs.job_position, jobs.job_location,
>          jobs.job_posted, stations.st_city, stations.st_name
>   FROM jobs, contacts, stations
>   WHERE jobs.con_id = contacts.con_id AND contacts.st_id = stations.st_id
>   ORDER BY jobs.job_title AND jobs.job_posted;

> I'm tying to have this returned record set be sorted by Job Title, and then
> by Posted date, when Job Titles are the same.


More information about the thelist mailing list