[thelist] Q on SQL 'ORDER BY'

jsWalter jsWalter at torres.ws
Fri Apr 9 18:35:24 CDT 2004

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?



sample output...

» Director of Traffic/Continuity [FT] - WOR Radio, New York City
   offer posted: 2004-03-17

» Assignment Editor [PT] - WHEC-TV, News/Weather/Sports, Rochester
   offer posted: 2004-04-07

» Clerical Assistant [FT] - WBNG-TV, Johnson City
   offer posted: 2004-04-07

» Producer [FT] - WSTM-WSTQ, Syracuse
   offer posted: 2004-04-09

» Sales Assistant [FT] - Clear Channel Radio, Albany
   offer posted: 2004-04-09

» Promotions Director [FT] - Infinity Broadcasting - Buffalo, Buffalo
   offer posted: 2004-03-19

» Promotion Writer/Producer [FT] - WRGB (CBS), Schenectady
   offer posted: 2004-04-07

» Test Title [PT] - WBNG-TV, Somewhere
   offer posted: 2004-03-22

» Main-line Producer [FT] - WSTM-WSTQ, Syracuse
   offer posted: 2004-03-08

» Senior Promotion Producer [FT] - WKBW-TV, Buffalo
   offer posted: 2004-04-07

More information about the thelist mailing list