create table aa(id int, sal int)						
create table bb(id int, sal int)

insert into aa values(1,100)
insert into bb values(1,200)

select * from aa
select * from bb

update aa set sal = (select bb.sal from bb inner join aa on aa.id=bb.id)