sql - denormalising ?

From: Carsten Jacobs <carsten.jacobs_at_web.de>
Date: Wed, 21 Mar 2001 15:14:32 +0100
Message-ID: <99acun$e8p0$1@ID-21443.news.dfncis.de>

Hi,

I have a table with multiple entries (2) for one entity like

id attribute

---

1 yellow
1 rough
2 blue
2 smooth

How can I get a result like
1 yellow rough
2 blue smooth

Do I need a procedure for that or can I do it with a single sql statement?

Many thanx for help

Carsten Received on Wed Mar 21 2001 - 08:14:32 CST