combining results by unique id

[striker77]

i get a list of results based on an id and based on a status value that can be 'active', 'inprocess' or 'cancel' - it is possible that the same user has both 'active' and 'inprocess' states associated with him and i want to combine the values for this user and show this result as 1 row instead of 2 rows - and I want to concatenate selected values that differ , so something like this - status='Active+ InProcess'

so i currently get something like the results below (the full row has a lot of data - please see full query at end of post):

id status
--------------------------
664 active
664 inprocess
199 cancel
103 active

i would like to get this

id status
--------------------------
664 active+ inprocess => the results for 664 collapsed to a single row
199 cancel
103 active

i can get the results for the id field by using "group by" but only if the id is the only selected field -

so i am able to get this using group by

id
---------
664
199
103

but it is missing the full data

I also looked at 'group by' and 'having' but doesn't quite seem to do it for a large number of selected values - they seem to all need to be in the group by if they are selected which loses the distinctness of just the id - is it some kind of aggregate thing? - any help would be great -

- Thanks!!!

this is the full query

==========
==========
-- the id value is attendeeid

SELECT ah.attendeeid, a.lastname, a.firstname,r.c heckindate,r.ch eckoutdate,
hp.hotelname, h.roomtype, rt.description as roomdesc, r.registrationi d, r.eventid, rt.hotelid,
ah.description, ah.original, a.email, ht.columnname, ah.attendeehist oryid, ah.historytype
FROM registration r, .reservation h,
room_types rt, hotel_profile hp, attendee_histor y ah,
attendee a, history_types ht
WHERE r.eventid=12
AND ah.attendeeid=h .attendeeid
AND ah.attendeeid=a .attendeeid
AND ah.attendeeid=r .attendeeid
AND ah.eventid=h.ev entid
AND ah.eventid=r.ev entid
AND h.roomtype=rt.r oomtype
AND rt.hotelid=hp.h otelid
AND ah.historytype= ht.historytypei d
AND ah.changeproces sed is null
AND h.roomtype is not null
AND ah.historytype in {10,11,21} -- 'active', 'inprocess' or 'canel' changes
AND ah.operation = 'Change'

[striker77]

I'm adding the relevant platform info below.

The query is run against db2.

The db2 server is Express 9.1 Fixpack 2
The platform is Windows Server 2003.