[thelist] Q on SQL 'ORDER BY'

Chris Murtland chris at studiomoxie.com
Fri Apr 9 19:09:15 CDT 2004


ORDER BY jobs.job_title, jobs.job_posted


On Fri, 9 Apr 2004 18:35:24 -0500, jsWalter 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.
> But that is not what is happening.
> I can't really tell what it's doing, except it's not doing what I
> thought it would do.
> Is my syntax wrong?

More information about the thelist mailing list