Re: Help with UPDATE!!!

From: <michael_bialik_at_my-deja.com>
Date: Wed, 13 Oct 1999 20:42:50 GMT
Message-ID: <7u2qs7$aae$1@nnrp1.deja.com>

Hi.

Assuming you have a unique/primary key CUST_ID in both tables :

UPDATE customer SET pnone_no = ( SELECT phone

                                  FROM CUSADDRESS CA
                                  WHERE ca.cust_id = customer.cust_id )

Good luck. Michael.

In article <3804b930.14472231_at_news.alterdial.uu.net>, vmillan_at_dailyherald.com (Vic Millan) wrote:
> I have two tables, CUSTOMER and CUSADDRESS.
> I need to update the phone field in CUSTOMER to be the same as the
> phone field in CUSADDRESS.
>
> I am new at this, so I need all the help I can get...
>
> Vic
> vmillan_at_dailyherald.com
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Oct 13 1999 - 15:42:50 CDT