HI

The SQL I am using is

update rafiq set RECIPIENTNAME = (select RECIPIENTNAME from rffragrecipient where
rafiq.shrfnbr=rffragrecipient.shrfnbr )

I am getting an error - subquery retieves more than 1 row .


Please tell em how should I write it

regards