Re: UPDATE command HELP!!

From: <michael_bialik_at_my-deja.com>
Date: Sat, 04 Dec 1999 08:15:44 GMT
Message-ID: <82aije$hes$1@nnrp1.deja.com>

Hi.

 Try :

 UPDATE customer cs

    SET acusno = ( SELECT phone FROM CUSADDRESS ca

                   WHERE ca.cusno = cs.cusno )

 WHERE acusno IS NULL;

 HTH. Michael

In article <3847ee49.6874827_at_news.alterdial.uu.net>,   vmillan_at_dailyherald.com (Vic Millan) wrote:
> 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
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Dec 04 1999 - 02:15:44 CST