update t_services_record services
set customer_id =(select customer.id from t_customer customer
where customer.customer_company=services.service_customer_name)
where exists (select 1
from t_customer customer where customer.customer_company=services.service_customer_name)
set customer_id =(select customer.id from t_customer customer
where customer.customer_company=services.service_customer_name)
where exists (select 1
from t_customer customer where customer.customer_company=services.service_customer_name)