Update using Same Table

[jetec]

I would like to update TABLE_A using TABLE_A.

Something like this...

UPDATE TABLE_A
(FLD_START)
=
(
SELECT fld_A from tbl_ref where tbl_ref.fieldB = table_a.fieldB from TABLE_A)

but i get a "too rows returned" error..

Any ideas or guidance?

Thanks
JE

 

[LKBrwnDBA]

Sure you don't get a SYNTAX error?


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[BJCooperIT]

This is pseudo code, right? The error is because:

SELECT fld_A from tbl_ref where tbl_ref.fieldB = table_a.fieldB from TABLE_A

is returning more than one row.

[sup]Beware of false knowledge; it is more dangerous than ignorance.[/sup][sup] ~George Bernard Shaw[/sup]
Consultant Developer/Analyst Oracle, Forms, Reports & PL/SQL (Windows)
My website: Emu Products Plus

 

[Beilstwh]

If you are simply trying to set the column FLD_START to the value of FLD_A then

update table_a
set fld_start = fld_a;



Bill
Oracle DBA/Developer
New York State, USA