[ask] INLINE / FLATTENED Views
490748Mar 7 2006 — edited Mar 15 2006Hi all,
I've a question regarding making a 'flattened' output from a simple query.
---
select ID, TEST, TEST_SCORE
from TEST;
output
----------
ID TEST TEST_SCORE
--- --------- ---------------------
5 GR01 490
5 GR02 530
8 SAT1 1100
8 SAT2 1250
8 GR01 520
-- My question is, how to delete the redundacies and make the output something look like this below? (note: disregard the arrow stuff)
ID GR01 GR02 SAT1 SAT2
-- -------- -------- ------- -------
5 -> 490 -> 530
8 -> 520 -> 1100 -> 1250
Thank you,
Gerald