麻烦各位高手了！！！！帮忙看看到底那里出错了

zhaoyang5566 2008-12-10 05:55:43

SELECT
ans.inq_answ_ctt
, ans.rgst_org_id
, (SELECT org_nm FROM zngm_org zo WHERE zo.org_id = ans.rgst_org_id) rgst_org_nm
, ans.rgstr_id
, SUBSTR(ans.rgst_dtm, 0, 8)rgst_dt
FROM ztpm_dsnet_op_plcy_inq_answ ans
WHERE ans.dsnet_plcy_id =:dsnet_plcy_id

提示有语法错误，以下是提示：
，(SELECT org_nm FROM zngm_org zo WHERE zo.org_id = ans.rgst_org_id) rgst_org_nm
..............1
PCC-S-02201, Encountered the symbol "org_nm" when expecting one of the following
:
( ) * + - / . @ | at, day, hour, minute, month, second, year,
The symbol ")" was substituted for "org_nm" to continue.
Syntax error at line 102, column 72, file pdb_ztpm_dsnet_op_plcy_inq_answ_f0002_2_1.pc:
Error at line 102, column 72 in file pdb_ztpm_dsnet_op_plcy_inq_answ_f0002_2_1.p
c
， (SELECT org_nm FROM zngm_org zo WHERE zo.org_id = ans.rgst_org_id) rgst_or
g_nm
.......................................................................1
PCC-S-02201, Encountered the symbol ")" when expecting one of the following:

...全文

70 3 打赏收藏转发到动态举报

写回复

用AI写文章

3 条回复

切换为时间正序

请发表友善的回复…

发表回复

zounf 2008-12-12

打赏
举报

"SUBSTR(ans.rgst_dtm, 0, 8)rgst_dt",别名前少空格.应改为"SUBSTR(ans.rgst_dtm, 0, 8) rgst_dt".
另外,","放前面总觉得怪怪的,建议改成这样吧:
SELECT ans.inq_answ_ctt,
ans.rgst_org_id,
(SELECT org_nm FROM zngm_org zo WHERE zo.org_id = ans.rgst_org_id) rgst_org_nm,
ans.rgstr_id,
SUBSTR(ans.rgst_dtm, 0, 8) rgst_dt
FROM ztpm_dsnet_op_plcy_inq_answ ans
WHERE ans.dsnet_plcy_id = :dsnet_plcy_id;

LJY_AINILU 2008-12-11

打赏
举报

是不是select出来了好多条记录？

Divina 2008-12-10

打赏
举报

(SELECT org_nm FROM zngm_org zo WHERE zo.org_id = ans.rgst_org_id) rgst_org_nm

变成 (SELECT org_nm FROM zngm_org zo WHERE zo.org_id = ans.rgst_org_id) AS rgst_org_nm

看看