select u.name,v.name from 现在有张表a u left join 现在有张表a v on u.manager=v.id where u.id=2
或者 select name, (select name from 现在有张表a where id=t.manager) from 现在有张表a t where id=2
可以是可以了 ,但是头标显示的不对 我想要的显示效果是 name manger x y y x而现在变成了 name name x y y x
select u.name,v.name as manger from 现在有张表a u left join 现在有张表a v on u.manager=v.id where u.id=2 select name, (select name from 现在有张表a where id=t.manager) as manger from 现在有张表a t where id=2
select u.name,v.name as manger from 现在有张表a u left join 现在有张表a v on u.manager=v.id where u.id=2
select a.name,b.name as manger from tt a left join tt b on a.manager=b.id where a.id=2
from 现在有张表a u left join 现在有张表a v on u.manager=v.id
where u.id=2
select name, (select name from 现在有张表a where id=t.manager)
from 现在有张表a t
where id=2
name manger
x y
y x而现在变成了
name name
x y
y x
from 现在有张表a u left join 现在有张表a v on u.manager=v.id
where u.id=2
select name, (select name from 现在有张表a where id=t.manager) as manger
from 现在有张表a t
where id=2
from 现在有张表a u left join 现在有张表a v on u.manager=v.id
where u.id=2
from tt a left join tt b on a.manager=b.id
where a.id=2