select name
from
(
select name, name as domain_name, 'domain' as type
from domain
union all
select sd.name, d.name as domain_name, 'subdomain' as type
from domain d
join subdomain sd on sd.domain_id = d.domain_id
)
order by domain_name, type, name;
或者只有一张桌子:
域(domain\u id,name,parent\u domain\u id)
使用此查询:
select name
from
(
select name, name as domain_name, 'domain' as type
from domain
where parent_domain_id is null
union all
select sd.name, d.name as domain_name, 'subdomain' as type
from domain d
join domain sd on sd.parent_domain_id = d.domain_id
)
order by domain_name, type, name;
您需要一个数据模型和一个SQL查询。你知道吗
您可以使用两个表:
使用此查询:
或者只有一张桌子:
使用此查询:
相关问题 更多 >
编程相关推荐