MySQL Forums
Forum List  »  Newbie

Re: GROUP_CONCAT question
Posted by: ben jaz
Date: August 18, 2014 01:31AM

Ps if i dpu them in 2 tables I can easily do this:

SELECT admin_nav.title, children.children FROM admin_nav
LEFT OUTER JOIN (SELECT Group_concat(title) AS children,
parent
FROM admin_nav_children
) AS children
ON children.parent = admin_nav.id
GROUP BY id
ORDER BY admin_nav.title

Options: ReplyQuote


Subject
Written By
Posted
August 17, 2014 02:14AM
August 17, 2014 12:29PM
August 18, 2014 01:26AM
Re: GROUP_CONCAT question
August 18, 2014 01:31AM
August 18, 2014 09:11AM


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.