http://stackoverflow.com/questions/1293330/how-can-i-do-an-update-statement-with-join-in-sql

create table sale

(

id int,

udid int,

assid int

)

create table ud

(

id  int,

assid  int

)

select * from sale

select * from ud

select *

from sale inner join ud on sale.id = ud.id

update sale set sale.assid = ud.assid

from sale inner join ud on sale.id = ud.id