Multiple Rows into One Row (concatenation?)

Database

Multiple Rows into One Row (concatenation?)

Hi all...newbie to Teradata so please excuse the ignorance.

I have the following set of results from a table:

ID Flag
77917 Credit Card Conversion
77917 Request to be Contacted
77917 Retention

Is there a way to get these results into one single row by concatenating the Flag field (or by some other means) so the results will look like this:

ID Flag
77917 Credit Card Conversion, Request to be Contacted, Retention

Thanks!
1 REPLY

Re: Multiple Rows into One Row (concatenation?)

Use a recursive query.

There is an example here:

http://carlosal.wordpress.com/2008/10/15/queries-recursivas-en-teradata/

HTH.

Cheers.

Carlos.