[RESOLVED] Sorting table content

dcjones

Hi all,

I have a table which has a number of fields two of which are "scheduledTime" and "iatalookup".

The "secheduledTime" filed is a TIME type and the "iatalookup" is a VARCHAR type.

I would like to sort the output by "scheduledTime" ASC and then by "iatalookup" ASC.

The query I have so far is:

SELECT ScheduledTime, Flight, Logo, IATALookup, RemarksWithTime, Terminal, Gate  FROM LHRFlightStats24 WHERE ArriveDepart = 'O'  AND  FlightDisplay = 'Y' ORDER BY ScheduledTime ASC, IATALookup ASC

The result is the "scheduledTime" is sorted ASC but the "iatalookup" is not. Am I doing this correctly.

bradgrafelman

Can you show us some of the rows that the above query returns and explain how you want them to be ordered differently?

dcjones

Hi Brad and thank you for your reply.

Using the query as is the output looks like:

| Time | Flight No | Departing to |

|06:00| LX 3452 | Zurich|
|06:05| BD 2311 | Vienna |
|06:10| TP 1298 | Lisbon |
|06:10| EE2177 | Brussels |
|06:20| BA 7765| Milan |

What I would like for the out put is:

|06:00| LX 3452 | Zurich|
|06:05| BD 2311 | Vienna |
|06:10| EE2177 | Brussels |
|06:10| TP 1298 | Lisbon |
|06:20| BA 7765| Milan |

where the two "06:10" flights are also sorted by the departing to.

This is the only way I could think of to display the output.

johanafm

The above is most likely not the output resulting from the query you posted. IATA codes are three (always?) letter airport codes while you are displaying actual city names.

dcjones

Hi all,

many thanks for the replies.

My original query works fine.

SELECT ScheduledTime, Flight, Logo, IATALookup, RemarksWithTime, Terminal, Gate  FROM LHRFlightStats24 WHERE ArriveDepart = 'O'  AND  FlightDisplay = 'Y' ORDER BY ScheduledTime ASC, IATALookup ASC

It was the way I was looking at the result. The result is what I required I am just blind.

Many thanks and sorry.