Table1
acct date
==================
111 01-jan-01
112 08-feb-00
113 18-mar-01
114 17-jun-00
115 21-jul-00
116 30-apr-00

Table2
acct status date1
=====================
111 open ?
112 cls ?
113 tbd ?
114 tbd ?
115 cls ?
116 open ?

Can someone please help me write a sql query to do the following:
I need to copy the values of table1, date column to table2, date1 column. The two tables can be linked by column acct. Both tables have
many other columns that are not listed here.
Thanks for your help.