ORA-01427 single-row subquery returns more than one row

This is my statement :

update relpersoonhierarchiek rel
set rel.soortfunctie =
(select fun.cat

 from fun_import fun
 where fun.id = rel.id)
where rel.id =
(select fun.id

 from fun_import fun
 where fun.id = rel.id)

ORA-01427: single-row subquery returns more than one row

Please help me. don't know what i'm doing wrong msg me on yeoen_at_sdu.nl please
thank's in advance Received on Thu May 26 2005 - 02:47:22 CDT