Question

oracle单行子查询返回多行

SELECT count（*）FROM JD_VIEW_PR_QUERY where ORL_RECVQTY >=0 AND sysdate < （SELECT max(DCK_RECVDATE) FROM R5DOCKRECEIPTS T,R5ORDERS T3 WHERE T.DCK_ORDER IS NOT NULL AND T.DCK_ORDER = T3.ORD_CODE GROUP BY T.DCK_ORDER）

Answer 1

单行子查询返回多于一个行

UPDATE LZ_CONT A SET (A.PYERNM) = (SELECT DISTINCT B.PYBKNA FROM SUNFRS.BEFIXSIGN B WHERE A.PYERBK = B.PYERBK) WHERE A.SIGNDT < '20141024';

这样试试，加一个distinct，因为(SELECT DISTINCT B.PYBKNA FROM SUNFRS.BEFIXSIGN B WHERE A.PYERBK = B.PYERBK)这个结果集里反回了多行颂丛数据，应该是重复的（如败樱携果你的逻辑没错的话察伏）加个distinct去重

追问

ELECT max(DCK_RECVDATE) FROM R5DOCKRECEIPTS T,R5ORDERS T3 WHERE T.DCK_ORDER IS NOT NULL AND T.DCK_ORDER = T3.ORD_CODE GROUP BY T.DCK_ORDER

有重复，但是应该不是去重的问题，应该是每一个结果都和系统日期进行比较，都记数