Take another try at your update statements.

Update ref set column = value

from

table ref

join othertable ref2 on ref.column = ref2.column

First google result I had found:

http://geekswithblogs.net/faizanahmad/archive/2009/01/05/join-in-sql-update--statement.aspx