mysql update select inner join

update gsk_all_to_creditchina a inner join(select company_name,type from ljx_108)b on a.company_name = b.company_name
set a.type = b.type;