SQL statement help please

From: Alan <alanpltse_at_yahoo.com.au>
Date: Fri, 01 Aug 2003 01:54:30 GMT
Message-ID: <3f29c855$1_at_news.comindico.com.au>

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 Fri Aug 01 2003 - 03:54:30 CEST