sqlserver 2008 多表更新

UPDATE a SET a.name = b.name FROM dbo.news1 a,dbo.news2 b WHERE a.news_id = b.news_id