Hi

I am not able to update a table cloumn using below query and getting ORA 01427: single row subquery returns more than one record error.

update fuctions f set id = (Select g.fn_id from access g where g.level = 'A' )
where f.u_id = "ABC";

I understand that problem is there with inner select query.

Can you please help me with this?

Thanks.

update fuctions f set id = (Select max(g.fn_id) from access g where g.level = 'A' )
where f.u_id = "ABC";