microsoft.public.cert.mcdba - SQL statement help please

Author

SQL statement help please

Alan

2003-07-31, 10:24 pm

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 !

Sponsored Links