oracle查询语句报标识符无效

Question

下面这个语句在

select BLDD from(select BLDD,YWDJRQ from POP_MARRIAGE where (ZFID=t.RKBSID or qzid =t.RKBSID) order by YWDJRQ desc)where rownum =1)as
P_CREATE_DIVISION  

这个地方报t.RKBSID标识符无效，请问下我的sql是哪里有问题呢？POP_PERSON表是有RKBSID这个字段的。
SQL全文如下：

select 
t.RKBSID as GUID,
t.XM as PERSON_NAME,
t.XB as GENDER,
t1.JKZK as HEALTH_STATE,
t.ZJLX as IDENTITY_TYPE,
t.ZJHM as IDENTITY_NUMBER,
t.CSRQ as BIRTHDAY,
t.MZ as ETHNIC_GROUP,
t.WHCD as EDUCATION_LEVEL,
t.GJ as NATIONALITY,
t.ZZMM as POLITICAL_LANDSCAPE,
t1.DSZNFMGRZBH as GLORIOUS_PERMIT_NUMBER,
t.SFDS as ONLY_CHILD,
t.LXDH as CONTACT_NUMBER,
t.ZY as EMPLOYMENT_STATUS,
t.GZDW as WORK_UNIT,
t.HYZK as MARITAL_STATUS,
t.HYBDRQ as CHANGE_DATE,
t.POBSID as P_GUID,
t.POXM as P_PERSON_NAME,
t.POGMSFHM as P_IDENTITY_NUMBER,
t.XJZD as LIVING_DIVISION,
t.XJZDXZ as LIVING_ADDRESS,
t.HJDXZ as HOUSEHOLD_ADDRESS,
t.SFBJQC as MARK_MOVE_OUT,
t.SFBJLK as MARK_MOVE_EXIT,
t.GDSJSFWZZJHM as PROVINCIAL_CERT_NUMBER,
t.GDSJSFWZLZRQ as PROVINCIAL_CERT_ISSUE_DATE,
t.LRBDRQ as MOVE_IN_DATE,
t.LCBDRQ as MOVE_OUT_DATE,
t.ZXYY as CANCEL_REASON,
t.ZXRQ as CANCEL_DATE,
t.LDZHM as NATIONAL_CERT_NUMBER,
t.LLDZRQ as NATIONAL_CERT_ISSUE_DATE,
t.LDZYXRQ as NATIONAL_CERT_EFFECTIVE_DATE,
t.JKRQ as move_CREATE_TIME,
t.JKR as move_CREATE_USER,
t.GXRQ as LAST_UPDATE_TIME,
(select xm from POP_PERSON where rkbsid=t1.QSMQBSID)as M_PERSON_NAME,
(select xm from POP_PERSON where rkbsid=t1.QSFQBSID)as F_PERSON_NAME,
(select CSRQ from POP_PERSON where rkbsid=t1.QSMQBSID)as M_BIRTHDAY,
(select CSRQ from POP_PERSON where rkbsid=t1.QSFQBSID)as F_BIRTHDAY,
(select ZJHM from POP_PERSON where rkbsid=t1.QSMQBSID)as M_IDENTITY_NUMBER,
(select ZJHM from POP_PERSON where rkbsid=t1.QSFQBSID)as F_IDENTITY_NUMBER,
t1.YWDJR as CREATE_DIVISION,
t1.YWGXRQ as CREATE_TIME,
t1.YWGXR as CREATE_USER,
(select CSRQ from POP_PERSON where rkbsid=t.POBSID)as P_BIRTHDAY,
(select  HYZK from POP_PERSON where rkbsid=t.POBSID)as P_MARITAL_STATUS,
(select  HYBDRQ from POP_PERSON where rkbsid=t.POBSID)as P_CHANGE_DATE,
(select BLDD from(select  BLDD,YWDJRQ from POP_MARRIAGE where (ZFID=t.RKBSID or qzid =t.RKBSID) order by YWDJRQ desc)where rownum =1)as
P_CREATE_DIVISION,
(select  max(YWDJRQ) from POP_MARRIAGE where ZFID=t.RKBSID or qzid =t.RKBSID)as
P_CREATE_TIME,
(select YWDJR from(select  YWDJR,YWDJRQ from POP_MARRIAGE where ZFID=t.RKBSID or qzid =t.RKBSID  order by YWDJRQ desc)where rownum =1)as
P_CREATE_USER
 from  POP_PERSON t left join  POP_CHILDREN t1 on t.RKBSID=t1.WYBS;

Answer 1

根据提供的 SQL 语句，我发现在第 34 行中的子查询语句中，最后一个 from 后面的左右括号似乎并没有配对，建议将最后一个右括号删掉，然后再试一下。具体如下：

(select BLDD from(select BLDD,YWDJRQ from POP_MARRIAGE where (ZFID=t.RKBSID or qzid =t.RKBSID) order by YWDJRQ desc)where rownum =1)as P_CREATE_DIVISION,

修改为：

(select BLDD from(select BLDD,YWDJRQ from POP_MARRIAGE where (ZFID=t.RKBSID or qzid =t.RKBSID) order by YWDJRQ desc) where rownum = 1) as P_CREATE_DIVISION,

另外，如果问题仍然存在，请再提供一下报错信息的完整内容，以便更好地进行排错。