我有一个Groups表,大约有1000个组和子组,它们与parent_id有关系,我想按id选择组和子组的子组,这是5 level组。我有一个返回一个子组的查询,我想返回所有级别的组,如果是,那么怎么做?

发布于 2016-03-10 07:24:26
根据您所提供的内容,您可以这样做:
SELECT a.group_name as 'Parent category', b.group_name as 'Sub-category 1' , c.group_name as 'Sub-category 2' , d.group_name as 'Sub-category 3' , e.group_name as 'Sub-category 4'
FROM Groups a
LEFT OUTER JOIN Groups b ON a.group_id = b.parent
LEFT OUTER JOIN Groups c ON b.parent = c.parent
LEFT OUTER JOIN Groups d ON c.parent = d.parent
LEFT OUTER JOIN Groups e ON d.parent = e.parent;这将在每个子组中得到一个结果(连接将为您提供一个子类别)。
https://stackoverflow.com/questions/35909912
复制相似问题