Update in a self join

I have a table and I would like to update some columns of a dataset of these table with values of another dataset of the same table.

I'm trying this way:

update tab_join_1 p
set p.nome =
(select n.nome from tab_join_1 n where n.key = p.key)
where exists
(select 'x'

 from tab_join_1 n
 where p.key = n.key);

I obtain an error of more rows returned in subquery.

Any help much appreciated.

Regards. Received on Fri Feb 09 2007 - 02:54:30 CST