Re: Update table from another table

In fact it should be written like this (at least, its the syntax I'd use)

update employee a
set a.fname = b.fname,

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

"Germano Silva" <germano-silva_at_home.com> wrote in message news:99q3g1$h67$1_at_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 - 10:37:53 CST