create table temp1(id varchar(10), num int) create table temp2(id varchar(10), num int)insert into temp1 values('001', 60) insert into temp1 values('002', 50) insert into temp1 values('003', 40) insert into temp1 values('004', 30)insert into temp2 values('001', 78) insert into temp2 values('002', 65) insert into temp2 values('003', 55)update temp1 set temp1.num = temp2.num from temp1,temp2 where temp1.id = temp2.idselect * from temp1
create table temp2(id varchar(10), num int)insert into temp1 values('001', 60)
insert into temp1 values('002', 50)
insert into temp1 values('003', 40)
insert into temp1 values('004', 30)insert into temp2 values('001', 78)
insert into temp2 values('002', 65)
insert into temp2 values('003', 55)update temp1 set temp1.num = temp2.num
from temp1,temp2
where temp1.id = temp2.idselect * from temp1