update VS4TEmployee2 Set Tem2AccountNo=(Select TEmBAccountNo From VS4TemployeeBank WHERE TEmBln=0 and VS4TemployeeBank.tEmbTEmpCode=VS4Temployee2.TEm2TEmpCode) WHERE Tem2AccountNo='' or Tem2AccountNo is NULL
GO
update VS4TEmployee2 Set Tem2AccountNo2=(Select TEmBAccountNo From VS4TemployeeBank WHERE TEmBln=1 and VS4TemployeeBank.tEmbTEmpCode=VS4Temployee2.TEm2TEmpCode) WHERE Tem2AccountNo2='' or Tem2AccountNo2 is NULL
GO