Need help on SQL

Hi all,

We have a master/detail table like this. Recently, we decided to move some of the colomn that belong to the Detail table to the master table (eg. in_date & out_date).

So I add the colomn on Master table and try to move the in_date & out_date data from the detail table to the master table. I try to do it with insert into but it doesn't work.

Any help will be appreciated. Thanks in advance.

MASTER
(

primary_key
other_data
...
in_date (recently created)
out_date (recently created)
)

DETAIL
(

foreign_key
other_data
...
in_date
out_date
) Received on Sun Sep 02 2001 - 11:13:01 CDT