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 !
