just corrected


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