Re: UPDATE command HELP!!

From: Ulrik Hoffmann <ulrik_at_hoffmann-kiel.de>
Date: Fri, 3 Dec 1999 18:41:50 +0100
Message-ID: <828vfe$2gh98$1@fu-berlin.de>

Hi Vic,

update CUSTOMER CM set CM.ACUSNO=
(select phone from CUSADRESSE CA where
CA.CUSNO = CM.CUSNO) Hope that helped,

Uli

> I have two table, CUSTOMER and CUSADDRESS.
> In the CUSTOMER table, I have a field called ACUSNO.
> Some data in CUSTOMER table has blank ACUSNO.
> I want to populate ACUSNO with a filed in CUSADDRESS called PHONE.
> The key for both tables is CUSNO.
>
> What is the correct syntax when I run UPDATE command??
>
> Vic
>
Received on Fri Dec 03 1999 - 11:41:50 CST