Update
a
set
a.Manage_FunctID=b.Manage_FunctID
From
Manage_PageUrl a
Left
join
Manage_ButtonBar b
on
a.Manage_PageUrlID=b.Manage_PageUrlID
Left
join
Manage_Funct c
on
b.Manage_FunctID=c.Manage_FunctID
多表联合修改
http://www.cnblogs.com/21xz/archive/2011/09/21/2183066.html