This is a question I have been seeking to have answered for some time now. Is it possible with MySql to basicaly SUM strings together from a join?
Suppose I have to table,
Table 1: Has ID# 50
Table 2: Has three rows that match table one for ID 50.
Now what I would like to do, is take the title (which would be a field) from table two and sum or concat it based on grouping ID#50 into a single row and a field that would have a group created based on the three rows from table 2.
Example:
Table 1: ID 50
Table 2:
| 50 | Jon
|50 | francine
| 50 | smith
Basically Group on 50 and the final single result that would be returned would look like this.
|50 | jon,francine,smith
This is a problem that has illuded for a long time and it would be really helpfull in a number of ways if I could do this what seems to be a simple thing. I would think many people in HTML or FORM development would like to be able to do something like this.
I know what I am trying to do can be accomplished with code, but their are times when I do not want to deal with large arrays for any number of reasons. And just comining the data into a comma delited format would allow me to parse data anyway I need without having to create routines to deal with mysql arrays.
Thanks in Advance
