SQL Statement Bulk update data (Multi-Table Association)

Recently encountered a problem in the project, the original design function is not required a specific field value depid, but the new features need to be based on depid to show, so there is a problem, the new added data have the correct depid, And the original large amount of data there is no depid or said depid not want to, facing the problem of batch update the original data depid.

The update involves three table Base_cooperativegroup,base_groupuser,base_user.

List the table structure:

1.base_cooperativegroup

2.base_groupuser

3.base_user

The update statements are as follows:

set base_cooperativegroup.depid=d.dwbh from (select from base_ Groupuser left join Base_user on Base_groupuser.useridwhere base_groupuser.isleader='1  '  ) dwhereisnull and  Base_ Cooperativegroup.groupid=d.groupid

OK, finished.