orcale查询info表中，p=1的数据，拿到这条数据的name存name1，orgcode存code1，再查询info表中per=orgcode的数据，拿到数据的name存name2，orgcode存code2， 这个sql怎么写 给出代码示例

SELECT t1.name AS name1, t1.orgcode AS code1, t2.name AS name2, t2.orgcode AS code2
FROM info t1
JOIN info t2 ON t1.orgcode = t2.per
WHERE t1.p = 1;