SQL statement help please

[Alan]

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 !

[Ray Higdon]

Re: SQL statement help please

Post your DDL and some insert statements and I'll play with this one.

Ray Higdon MCSE, MCDBA, CCNA

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!