Re: Update table from another table

When I tried the command:

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

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

It returns error:

Server: Msg 170, Level 15, State 1, Line 1 Line 1: Incorrect syntax near 'a'.

In comp.databases.sybase Michel Roberge <mrobergeNO_at_spamstarlims.com> wrote:
> 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
>>
>>

-- 
e-Consultant
http://www.asl.com.hk/employment.htm
http://www.eroom.com