SashaBuilder3
Programmer
Hi everybody,
I am trying to update a table with values from another table.
Here is a simplified scenario of what I wanna do:
Table t1:
fld1 fld2
---------
a 5
b
c 3
d
e 7
f
Table t2:
fld1 fld2
---------
b 2
d 1
f 3
I need to transfer values of t2.fld2 to corresponding cells of t1.fld2.
I issued the following SQL statement:
UPDATE t1
SET fld2 = (SELECT fld2
FROM t2
WHERE t2.fld1 = t1.fld1
)
WHERE fld1 IN (
SELECT fld1
FROM t2
)
However it the query doesn't work, I am getting an error message:
ORA-01427: single-row subquery returns more than one row
Can anyone help in writing a correct query?
Thanks,
Alexandre
I am trying to update a table with values from another table.
Here is a simplified scenario of what I wanna do:
Table t1:
fld1 fld2
---------
a 5
b
c 3
d
e 7
f
Table t2:
fld1 fld2
---------
b 2
d 1
f 3
I need to transfer values of t2.fld2 to corresponding cells of t1.fld2.
I issued the following SQL statement:
UPDATE t1
SET fld2 = (SELECT fld2
FROM t2
WHERE t2.fld1 = t1.fld1
)
WHERE fld1 IN (
SELECT fld1
FROM t2
)
However it the query doesn't work, I am getting an error message:
ORA-01427: single-row subquery returns more than one row
Can anyone help in writing a correct query?
Thanks,
Alexandre