SQL statement help please

I have the following cutdown version of table:

VehicleID Time Station
------------- ------- ----------

1                9:00     A
1                9:10     B
1                9:20     C
1                9:30     A
1                9:40     B
1                9:50     C
1                10:00   D
1                10:10   E

I want to display the table as follows:

VehicleID A B C D E

1                     9:00  9:10  9:20
1                     9:30  9:40  9:50  10:00  10:10

Station A is the starting point.

I am using MySQL so could you guru give me any idea of the ANSI SQL rather than MS SQL Server specific, thanks ! Received on Thu Jul 31 2003 - 20:54:30 CDT