Re: Need help on SQL

<hartono_nugroho_at_attglobal.net> wrote in news:3b932fac_2_at_news1.prserv.net:

> 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
> )
>
>
>

Try using UPDATE instead of INSERT Received on Mon Sep 03 2001 - 11:49:36 CDT