hi:

i have 2 tables. t1 and t2. im trying to insert data in a field in t1 from a field in t2. the field is called F. t1 has data in its other columns but empty in the F. thats why i want to insert the data from t2 to t1 in the respective column F. i wrote the below code:

UPDATE T1
SET F= ( SELECT F FROM T2 WHERE T2.Key = T1.KEY)

i get this error:
ORA-01427: single-row subquery returns more than one row

kindly help me. where am i going wrong?

Thanks

The error message says it all. You have more than one row in T2 where the T2.Key value is equal to some T1.Key value. The subquery returns all the rows in T2 where the Key values are equal. Since there is more than one row for some T1.Key, the error is generated because which value of F from the several rows should it use to update that row in T1?

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com