Re: Update table from another table

From: Germano Silva <germano-silva_at_home.com>
Date: Tue, 27 Mar 2001 08:10:25 -0500
Message-ID: <99q3g1$h67$1@saturn.services.brown.edu>

The following should work .

update employee
set fname = b.fname,

lname = b.lname
from employee a, employee_bk b
where a.emp_id = b.emp_id

"CSC" <jcheong_at_cooper.com.hk> wrote in message news:99pqks$75f28_at_imsp212.netvigator.com...
> In Oracle, I can issue the following command to update table:
>
> update employee a
> set (a.fname,a.lname) =
> (select b.fname,b.lname
> from employee_bk b
> where a.emp_id = b.emp_id )
>
> What is the corresponding command in Informix and SQLServer?
>
>
>
>
>
> --
> e-Consultant
> http://www.asl.com.hk/employment.htm
> http://www.eroom.com
Received on Tue Mar 27 2001 - 07:10:25 CST