Grouping results horizontally in SQL

Hi All

I'm sure this must have been asked before, but I can't for the life of me find anything in the Archives, so my apologies if that's the case.

I have an order header file with a separate record for each account/year/period key combination. For example

Account Year Order
------- ---- -------
1000 2012 10001
1000 2012 11023
1000 2012 12700
1000 2012 13508
2000 2012 1255

Ideally I would like to see the results as shown below:

Account Year Orders
------- ---- --------
1000 2012 10001, 11023, 12700, 13508
2000 2012 1255

I have been looking online and can see solutions that might help, but they are for different flavours of SQL and use functionality that isn't present within our version (v6r1),of SQL.

Has anybody come across a method of doing this?

Thanks

Jonathan


Proud partner of The Ageas Bowl and the Ageas Salisbury International Arts Festival.

Registered Address: Ageas House Tollgate Eastleigh Hampshire SO53 3YA Registered Number: 354568 England
Authorised and regulated by the Financial Services Authority

This e-mail together with any attachments are intended for the addressee only and may be private and confidential. If you are not the intended recipient, or the person responsible for delivering it to the intended recipient, you must not open any attachments, or copy, disclose, distribute, retain or use this e-mail, including any attachments, in any way whatsoever; please return it to us immediately using the reply facility on e-mail.

Consider the environment and think before you print this email.