Hi, All.
Do you know how make concatenate of column values (TEXT type) with group by
other column?
I need do it use only SQL query!!!
For clearness, please, take a look on example.
I have table:
id c1 c2
1 1 "apple"
2 1 "plum"
3 1 "vine"
4 2 "apple"
5 2 "pear"
6 3 "vine"
7 3 "ananas"
I wash get a temporary:
t1 t2
1 "apple", "plum", "vine"
2 "apple", "pear"
3 "vine", "ananas"
Best regards.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php