SQL的UPDATE联查更新语句,开始想都没想就要这样做,然后语法出了上网查了下,还真有,以前没这样试过,记录一下方便回忆

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

  

posted on 2011-09-21 09:07  花祭果凛  阅读(36631)  评论(2编辑  收藏  举报