UPDATE clientes_perfiles SET `id_customer` = (SELECT customer_id FROM one_customers_profiles_assign WHERE one_customers_profiles_assign.profile_id = clientes_perfiles.id LIMIT 1); tes_perfiles.id);