Is s_subjectid - a key in both: s_subject and annmarie tables? Regards, Igor Neyman On Thu, Feb 17, 2011 at 3:06 PM, Zelli, Brian <Brian.Zelli@xxxxxxxxxxxxxxx>wrote: > SQL> UPDATE s_subject > 2 SET u_mrn = (SELECT u_mrn FROM annmarie.s_subject > 3 WHERE annmarie.s_subject.s_subjectid = s_subject.s_subjectid) > 4 where exists > 5 (SELECT u_mrn FROM annmarie.s_subject > 6 WHERE annmarie.s_subject.s_subjectid = s_subject.s_subjectid); > SET u_mrn = (SELECT u_mrn FROM annmarie.s_subject > * > ERROR at line 2: > ORA-01427: single-row subquery returns more than one row > > Ok, I am trying to update the mrn data based on the subjectid's being > equal. It errors saying: > This is a key and there shouldn't be any duplicates. An example I saw uses > the same code. > > What is wrong with the code? > > > > Brian > > > > This email message may contain legally privileged and/or confidential > information. If you are not the intended recipient(s), or the employee or > agent responsible for the delivery of this message to the intended > recipient(s), you are hereby notified that any disclosure, copying, > distribution, or use of this email message is prohibited. If you have > received this message in error, please notify the sender immediately by > e-mail and delete this email message from your computer. Thank you.