update Account set gender= BasicInfo .Gender from Account inner join BasicInfo on Account.AccountID = BasicInfo .AccountID