mysql更新A表的字段等于B表的字段

UPDATE 
sdb_b2c_flash_users AS fu,
sdb_b2c_members AS m,
sdb_b2c_flash_third_stations AS d  
SET 
fu.account_id=m.member_id,
fu.team_code='2324',
fu.name=m.name 
WHERE d.real_id=fu.real_id AND d.third_real_id='0000100137' AND m.mobile='18637613439';

更新sdb_b2c_flash_users表的team_code=2324，name等于sdb_b2c_members表的name，account_id等于
sdb_b2c_members表的member_id