MySQL Forums
Forum List  »  MySQL Query Browser

Re: SQL Join
Posted by: Jay Narayan
Date: January 11, 2013 10:21PM

group_concat might do the trick

http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html#function_group-concat

SELECT p.fld_parent_name, group_concat(c.fld_ans)
FROM tbl_parent_child_details p
JOIN tbl_feedback_children c ON p.fld_parent_id = c.fld_parent_id
GROUP BY p.fld_parent_name

Options: ReplyQuote


Subject
Written By
Posted
December 16, 2012 02:31PM
Re: SQL Join
January 11, 2013 10:21PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.