) AS KEY3VAL
FROM T1, T2
WHERE T1.INDEX = T2.IND
GROUP BY T1.INDEX ;
Henry
-Original Message-
From: Volker Paul [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 04, 2000 2:30 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [SQL] SQL (table transposition)
[EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
>
> Is there any way to get table T3 (below) from T1 and T2 using SQL (select, view,
>etc)?
>
> T3 is basically all INDEX values from T1 matched to IND from T2 with the
>corresponding KEY/VALUE pairs transposed from rows to columns.
>
> ---
> |INDEX| (T1)
>
Hope you like black magic :)
SELECT IND AS T1_INDEX, MIN(CASE WHEN KEY=1 THEN VALUE ELSE NULL END) AS
KEY1VAL, MIN(CASE WHEN KEY=2 THEN VALUE ELSE NULL END) AS KEY2VAL, MIN(CASE
WHEN KEY=3 THEN VALUE ELSE NULL END) AS KEY3VAL FROM T2 GROUP BY IND ORDER BY
IND;
Mark
[EMAIL PROTECTED] wrote:
>
>
Is there any way to get table T3 (below) from T1 and T2 using SQL (select, view, etc)?
T3 is basically all INDEX values from T1 matched to IND from T2 with the corresponding
KEY/VALUE pairs transposed from rows to columns.
---
|INDEX| (T1)
---
| 1 |
| 2 |
| 3 |
---
