Question

ORA-01427: 单行子查询返回多个行，，，，，在线等、、、、

select NULL as mc,
'<a href=CardPage.aspx?PU=200004&querycondition=val_WO_DESCRIBE,,;;val_WO_JSDW,,;;val_WO_SYDW,,;;val_WO_ZGDW,,;;val_WO_XMXZ,,;;val_PROVIDER_NAME,,;;val_SSRQ,,;;val2_SSRQ,,;;val_SDRQ,,;;val2_SDRQ,,;;val_YS,,;;val_ES,,¤tpageindex=1&PKValue=' ||
WO_NO || '><img src=../css/edit.gif border=0></a>' as edit,
NULL as del,
NULL as xh,
YJS_JSSDQKMX_VW.WO_NO as WO_NO,
YJS_JSSDQKMX_VW.WO_DESCRIBE as WO_DESCRIBE,
YJS_JSSDQKMX_VW.WO_JSDW as WO_JSDW,
YJS_JSSDQKMX_VW.WO_SYDW as WO_SYDW,
YJS_JSSDQKMX_VW.WO_ZGDW as WO_ZGDW,
YJS_JSSDQKMX_VW.WO_XMXZ as WO_XMXZ,
YJS_JSSDQKMX_VW.PROVIDER_NAME as PROVIDER_NAME,
YJS_JSSDQKMX_VW.WO_PRECOST as WO_PRECOST,
YJS_JSSDQKMX_VW.SSRQ as SSRQ,
YJS_JSSDQKMX_VW.PRESET_SHZJ as PRESET_SHZJ,
YJS_JSSDQKMX_VW.YSDJ as YSDJ,
YJS_JSSDQKMX_VW.PRESET_TOTAL as PRESET_TOTAL,
YJS_JSSDQKMX_VW.ZCZ as ZCZ,
YJS_JSSDQKMX_VW.SJ as SJ,
YJS_JSSDQKMX_VW.SDRQ as SDRQ,
YJS_JSSDQKMX_VW.YS as YS,
YJS_JSSDQKMX_VW.ES as ES
FROM YJS_JSSDQKMX_VW
Where 1 = 1
and ssrq is not null

Answer 1

ORA-01427: 单行子查询返回多个行

说明一行数据对应了多行数据，它不知道该匹配哪个，你可以使用min、或max函数取多行数据的最大或最小值完成匹配！

Answer 2

这个sql并无问题，YJS_JSSDQKMX_VW是一张视图？

追问

是的。执行的时候报
ORA-01427: 单行子查询返回多个行
您知道是属于那种情况吗。

追答

问题应该出在视图中。你重点检查一下有没有 =(select ...) 或者 (select ...)= 的语句。不行的话把视图代码贴上来

追问

追答

第7行，项目类别那里。这个子查询返回了多个值。你检查一下