Update (select a.cards_name testa ,b.usergender testb from tb_user_cards a,tb_user b where a.cards_id=b.id) set testa=testb