retrieving in a reverse order...

• Ahmed Yarub Hani

  Mr or Mrs. 500

  Points: 547

  More actions

  August 27, 2007 at 2:20 am

  #197525

  hi everybody

  i've the following code:

  SELECT DailyReport.*, DailyReport_ExecutedWorks.Company, DailyReport_ExecutedWorks.ManPower, DailyReport_ExecutedWorks.Equip, DailyReport_ExecutedWorks.Description FROM DailyReport INNER JOIN DailyReport_ExecutedWorks ON DailyReport.DailyReportRef=DailyReport_ExecutedWorks.DailyReportRef;

  that's used to retrieve some records

  but i want to retrieve them in a reverse order

  and i don't mean reverse alphabetical order...

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  August 27, 2007 at 3:22 am

  #729495

  Ahmed,

  maybe it would help if you told us what type of order you mean.  WHich field you want to be ordered ? Maybe some sample output would help.

  Markus

  [font="Verdana"]Markus Bohse[/font]

• John Eisbrener

  SSC-Addicted

  Points: 489

  More actions

  August 27, 2007 at 7:08 am

  #729517

  Append ORDER BY [COLUMN NAME 1] DESC, [COLUMN NAME2] DESC, etc.