Joshua Beall wrote:
"Wolfram Kraus" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
Use GROUP BY with GROUP_CONCAT:
http://dev.mysql.com/doc/mysql/en/group-by-functions.html
Thanks, I'll take a look and see if I can figure that out. I wasn't
aware of the GROUP_CONCAT function; it looks like that might be just
what I need.
Any examples that apply to my situation would be greatly appreciate!
:-)
Sincerely, -Josh
Untested!!! (No 4.1 available here)
SELECT GROUP_CONCAT(child1.fname)
FROM parent
LEFT JOIN child ON parent.ID = child.parentID
GROUP BY(parent.ID)
You may also need some string functions:
http://dev.mysql.com/doc/mysql/en/string-functions.html
HTH,
Wolfram
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
