update t_cus_info t5,(select t1.F_CUS_CODE ,t2.F_USER_SHOP_REL from t_cus_sales_rel t1 LEFT JOIN t_shop_user_info t2 on t1.F_USER_CODE = t2.F_USER_CODE ) t3 
set F_REGISTER_SHOP  = t3.F_USER_SHOP_REL
where t5.f_cus_code = t3.f_cus_code