RHEL4.310.2.0.2RAC
确定t2.id存在, 为什么会报这样的错误呢?谢谢大家!
SQL> create or replace view T_JOB_MESSAGE_V as
2select t1.ID,
3
t1.COMPANY_NAME,
4
t2.ID,
5
t2.JOB_TITLE,
6
t2.DESCRIPTION,
7
t2.PROVIDER_WEBISTE_ID,
8
t3.WEBISTE_NAME,
9
t2.PROVIDER_URL,
10
t2.POST_TIME,
11
t2.LOCATION
12
from T_JOB_COMPANIES t1,T_JOB_POSITIONS t2,T_SYS_WEBSITES t3
13
where t2.PROVIDER_WEBISTE_ID = t3.id
14and t2.comp_id=t1.id
15and t2.status=\'1\';
t2.id,
*
ERROR 位于第 4 行:
ORA-00957: duplicate column name
|