Are you trying to insert date from table1 to table2(date1)?
If yes, then

insert into table table2
(date1)
select a.date from table1 a , table2 b where
a.acct =b.acct ;