return transactions from supermarket

djuritz · #1 (**permalink**) 06-13-10, 21:33

Hi all,

I need to convert data from the following format:

TRANS_ID PRODUCT
1 A
1 B
1 C

to the following format:

TRANS_ID PRODCUTS
1 A,B,C

Is there any function to return data like this ?

Thanks

r937 · #2 (**permalink**) 06-14-10, 06:11

Quote:

Originally Posted by djuritz

Is there any function to return data like this ?

yes, the GROUP_CONCAT function

djuritz · #3 (**permalink**) 06-14-10, 16:35

Quote:

Originally Posted by r937

yes, the GROUP_CONCAT function

Thanks!!
That's what I needed! :-)

Internet Services

Web Development

Digital Marketing

Consumer Tech