Re: little sql help

From: <steveee_ca_at_my-deja.com>
Date: Mon, 25 Dec 2000 15:01:41 GMT
Message-ID: <927ngj$n4g$1@nnrp1.deja.com>

Hi ,

A very quick answer:

update something..
set col = something
where id = (select id from othertable
where...)

Hth,

Steve

In article <927fp4$6a6$1_at_bob.news.rcn.net>, "Ed Zappulla" <zappullae_at_rcn.com> wrote:
> Hi, I need a little help with an update statement. I have 2 tables
linked
> by id and want to update table A with some data in table A. I want to
set
> table B's last and first name from table A's. Ideas?
>
> A:
> id
> last_name
> fist_name
>
> B:
> id
> last_name
> fist_name
>
>

Sent via Deja.com
http://www.deja.com/ Received on Mon Dec 25 2000 - 09:01:41 CST