471,108 Members | 1,289 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,108 software developers and data experts.

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 !
Jul 20 '05 #1
1 1823
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!
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Jay | last post: by
8 posts views Thread by Rick | last post: by
18 posts views Thread by dspfun | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.