Can rows be upadted along with the colums for a table.  

I had a table where amount was to be updated for single member for 3 different years

I used the following query

```
update ahd
   set amount1=(select a.amnt1
                  from ahd inner join ahdtmp a on ahd.member_key=a.member_key
                 where ahd.date1=a.date1
                   and a.status='FALSE'
                   and a.member_key in (select distinct member_key
                                          from ahd))

```

When I execute this

> 
> ERROR at line 2:  
> 
>  ORA-01427: single-row subquery returns more than one row
> 
> 
> 

The temporary table is ahdtmp

```
create table ahdtmp(
member_key number(10),
date1 date,
amnt1 number(10,2),
amnt2 number(10,2),
date_amend date,
Status varchar2(10));

```

Please suggest on this?

What could have gone wrong..