如何通过code查询p表的name 查询结果是 p表 1:eeeee ddddd 2:aaaaa bbbbb 3:ccccc cccccc 4: bbbbb eeeeee
如何通过code查询p表的name 查询结果是 p表 1:eeeee ddddd 2:aaaaa bbbbb 3:ccccc cccccc 4: bbbbb eeeeee
[code="sql"]select *
from (
select *
from p
left join master
on code = code1
as tmp
)
left join master
on code = tmp.code2
[/code]
没测不一定对