MySQL Joins Question 1

[pseudosig]

Suppose you have the following tables:

t1

 _c1_c2_
| a | 1 |
| a | 9 |
| a | 4 |



t2
 _c1____c2__
| a | alpha |
| b | beta  |

Is there a way to query the two tables (perhaps a weird join) that would return the following?:

 _t2.c1___t2.c2___(something here)_
|   a   | alpha |     1,9,4        |

Basically, a join-like query that would bundle multiple data, like that in t1.c2, into a single row?

Thanks in advance...

 

[guelphdad]

yes, you need to use GROUP_CONCAT

select t2.c1, t2.c2, group_concat(t1.c2) as mygroupalias
from t1 join t2
on t1.c1=t2.c2
group by
t2.c1,
t2.c2

 

[towerbase]

That's cool. I wasn't aware of GROUP_CONCAT. Worth a star.

Andrew
Hampshire, UK

 

[guelphdad]

They added group_concat in version 4.1 always useful.