Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help on sql-query
Message
From
11/09/2008 02:34:50
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Help on sql-query
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01346517
Message ID:
01346517
Views:
43
I have a table with values

empno year amt
A 2004 45.23
A 2005 54.56
A 2006 89.56
B 2004 44.33
B 2005 22.15
B 2006 48.98
C 2004 55.00
C 2005 56.13
C 2006 44.56


How can I have a table that will appear like this
empno 2004 2005 2006
A 45.23 54.56 89.56
B 44.33 22.15 48.98
C 55.00 56.13 44.56
Next
Reply
Map
View

Click here to load this message in the networking platform