[This message has also been posted.]
I have a table looking like this:
ID | Code | Value
-----+--------+-------
A | T | V1
A | P | V2
A | S | V3
B | T | V4
B | P | V5
B | S | V6
And I want to turn it into a table like:
ID | Temp | Pres | Saturation
-----+--------+--------+------------
A | V1 | V2 | V3
B | V4 | V5 | V6
Is it possible to do this via an SQL Query at all???
Mark
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz