联表更新

SQL Server示例: 

[update] a set a.name=b.name,a.age=b.age from user a,member b where a.id=b.id

参考：http://blog.163.com/lgh_2002/blog/static/44017526200911405956773/