mysql关联更新

update tb_sdd_info a,tb_bnm_evian_info b set a.username=b.username where a.username=b.memberno and  year(a.createtime) = 2012 and month(a.createtime)=11;