How can you create a flatten table in SQL

    Is there a way to create a flattened table in SQL using such data as this:

id type suff

12    3        0
12    3        0
12    4        1
12    4        1
12    4        1
12    4        1
12    5        2
12    5        2
12    5        2

select id||'-'||type||'-'||suff,
?

from pop
?

output would be:

field1 field2 field3
12-3-0 12-4-1 12-5-2

thanks in advance for any ideas

j Received on Wed Nov 24 1999 - 20:04:24 CET