[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.
<snipped>
More information about the thelist
mailing list