Sql(10分)

有Table1
iID 姓名 模块 权限
.......................
......................
1 ‘张’ 1 T
1 '张' 2 F
.....................
.....................
2 ‘李’ 2 T
3 ‘王’ 3 T
.....................
.....................
Table2
iUserGroupID iID 模块 权限
..........................................
..........................................
10 1 1 F
10 1 2 T
.........................................
.........................................
现在改table1 的权限，让他符合Table2 怎么把他们连起来改？？

Update Table1
Set 权限=(Select 权限 From Table2 Where iID=Table1.iID And 模块=Table1.模块)

Update Table1
Set 权限=A.权限
From Table2 A
Where A.iID=Table1.iID And A.模块=Table1.模块