[thelist] Q on SQL 'ORDER BY'

[Chris Murtland]

Try 

ORDER BY jobs.job_title, jobs.job_posted

Chris

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?