Update table by join

update a set a.cusip12 = b.cusip9 from AAA a,BBB b where
a.xxx= b.xxx