ORA-00918:未明确定义列,该怎么处理

ORA-00918:未明确定义列
下面是我的代码

select rownum rn,t__.* from (
 select * from users us, post pt,state se,branch bh 
  where us.branch_id=bh.branch_id 
  and us.post_id=pt.post_id 
  and us.state_id=se.state_id  
  and bh.branch_name like '%' 
  and pt.post_name like '%'
  and us.users_name like '%'
  and us.users_id like '%'
 ) t__ 


如果只要最中间括号内的语句 就能够正常显示,一旦嵌套一层括号,就出现标题错误,如果给t__.* 就不报错了,求大神解决

[解决办法]

SQL code

-- 查询1：11:18:52 SCOTT@tdwora > select rownum rn, t__.* from (11:19:46   2  select e.deptno, e.ename, d.deptno, d.loc11:19:46   3  from emp e, dept d11:19:46   4  where e.deptno=d.deptno ) t__;select rownum rn, t__.* from (                      *第 1 行出现错误:ORA-00918: 未明确定义列-- 查询2(将查询1中的子查询涉及到的两个同名字段 deptno去掉一个)11:19:47 SCOTT@tdwora > select rownum rn, t__.* from (11:20:11   2  select e.deptno, e.ename, d.loc11:20:11   3  from emp e, dept d11:20:11   4  where e.deptno=d.deptno ) t__;        RN     DEPTNO ENAME      LOC---------- ---------- ---------- -------------         1         10 KING       NEW YORK         2         10 CLARK      NEW YORK         3         20 FORD       DALLAS         4         20 ADAMS      DALLAS         5         20 JONES      DALLAS         6         20 SMITH      DALLAS         7         30 BLAKE      CHICAGO         8         30 MARTIN     CHICAGO         9         30 WARD       CHICAGO        10         30 TURNER     CHICAGO        11         30 ALLEN      CHICAGO已选择11行。
[解决办法]
select * from users us, post pt,state se,branch bh 
 where us.branch_id=bh.branch_id   and us.post_id=pt.post_id   
 and us.state_id=se.state_id  
 and bh.branch_name like '%' 
 and pt.post_name like '%'
 and us.users_name like '%'
 and us.users_id like '%'

你查询结果里 包含了重复的字段（标红）