Newbie SQL problem with UPDATE - SQL0811

[Bob Schwartz <rschwartz@xxxxxxxxxxxxxxx>]

I'm trying to update a file with values from another file using the QM SQL statement below.

I keep getting SQL0811 - Result of select more than one row.

Can someone help me out, I've been all over the place and can't figure this one out.

Actually found some of this searching the archives - Thanks  Elvis B.



Thank you, Bob



        ************************** Beginning of Data *********************************

 0001.00 UPDATE LRACCTWF a  SET a.number   =

 0002.00   COALESCE((SELECT b.number

 0003.00    FROM   LRICEXTWF b

 0004.00    WHERE DIGITS(a.lrpin) = substr(b.stude00001,1,5)),number)

 0005.00 WHERE EXISTS

 0006.00  (SELECT b.number

 0007.00   FROM   LRICEXTWF b

 0008.00    WHERE DIGITS(a.lrpin) = substr(b.stude00001,1,5))

         ***************************** End of Data ************************************