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
Subject
Written By
Posted
Re: GROUP_CONCAT question
August 18, 2014 01:31AM
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.