update mem_memberaccount

update mem_memberaccount set level=4 where id in (select id from (select a.id,a.uniqueid,a.levelname,b.level from mem_memberbaseinfo a,mem_memberaccount b where a.id=b.id) x where level='5' and levelname<>'vip');