存货核算期末反结账的时候报错
云社区用户81Uv5361
1人赞赏了该文章
539次浏览
编辑于2016年08月03日 12:07:38
update T_IM_PurInWarehsBill as bill set (FFIVouchered,FVoucherId)=(select 1 as FFiVouchered,pinvoucher.FVoucherId from T_IM_PurInWarehsVoucher as pinvoucher inner join t_gl_voucher as voucher on voucher.fid=pinvoucher.FVoucherID where bill.fid=pinvoucher.FBillID and voucher.fPeriodID='Ut4AAAAJoQ6COIxM' AND PINVOUCHER.FCommpanyOrgUnitId='Ut4AAAAAB+fM567U' and pinvoucher.FVoucherType=1)
ORA-01427:single-row subquery returns more than one row
目前没有找到相关的原因，还请谁大侠能指导下
PurInWarehsVoucher 这张表是什么表啊
推荐阅读