update u set u.type2=b.type2 from userinfo u,buildapplication b where u.userid=b.userid
update u set u.type=b.type from userinfo u,buildapplication b where u.userid=b.userid
update u set u.type2=b.type2 from userinfo u,buildapplication b where u.userid=b.userid
update u set u.type=b.type from userinfo u,buildapplication b where u.userid=b.userid