Question

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

ORA-01427: 单行子查询返回多于一个行
SELECT
BillNo,SerialNo,DepId,DepCode,DepName,PluId
,PluCode,PluName,BarCode,Spec,ExPluCode,ExP
luName,Unit,PcGUID,PcNo,PackUnit,PackQty,Pa
ckCount,SglCount,CsCount,PluType,HJPrice,WJ
Price,NewHJPrice,NewWJPrice,NewPcGUID,NewPc
No,JTaxRate,HCost,WCost,WhyCs,StatusText,Re
mark, (SELECT a.IsExPluCode FROM tSkuPlu a
WHERE a.PluCode=tStkCsBody.PluCode ) AS
IsExPluCode,NewHCost,NewWCost, (SELECT
a.JTaxCalType FROM tSkuPlu a WHERE
a.PluCode=tStkCsBody.PluCode ) AS
R_JTaxCalType FROM tStkCsBody Where BillNo
= '1005LSCS201006170005'

Answer 1

跟我遇到同样的问题.update house_goufbtsqxin a
set shurusj=(select b.shurishijian from house_dsrjtgmzfzcxbtff b,house_goufbtsqxin a where b.processid=a.processid)
where exists (select 1
from house_dsrjtgmzfzcxbtff b,house_goufbtsqxin a
where b.processid = a.processid
)但是未能解决.......我也很头疼.