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




