看看这个,最好能有一个是否你的意思?(最好有个对照表)select a.*,b.name from (select * from t_posi_role where a.relation_id=:val1001) a join (select '0' pos,'CSR' name from dual union select '1' pos,'班长' name from dual union select '2' pos,'管理员' name from dual union select '3' pos,'工单处理人员' name from dual union select '4' pos,'部门工单处理人员' name from dual) b on a.a1(+)=b.pos
(select * from t_posi_role where a.relation_id=:val1001) a join
(select '0' pos,'CSR' name from dual
union
select '1' pos,'班长' name from dual
union
select '2' pos,'管理员' name from dual
union
select '3' pos,'工单处理人员' name from dual
union
select '4' pos,'部门工单处理人员' name from dual) b on a.a1(+)=b.pos