两表查询sql语句写法，难呀

如何通过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]

没测不一定对