GROUP_CONCAT (MySQL >= 4.1)

Азат Разетдинов 23.03.2007 00:57

SELECT
	p.parent_id,
	p.parent_name,
	GROUP_CONCAT (c.child SEPARATOR ', ') AS child
FROM
	parents p,
	children c
WHERE
	p.parent_id = c.parent_id
GROUP BY
	p.parent_id