这行得通吗?
select r0.id
from my_table as r0
join my_table as r1 on(r0.parent_id = r1.id)
join my_table as r2 on(r1.parent_id = r2.id)
where r0.alias='nickf'
and r1.alias='admins'
and r2.alias='users'
and r2.parent_id is null
在我看来,实际上并不需要嵌套的子查询。
还是我错了,错过了什么?