标题: 请教mysql查询优化 [打印本页] 作者: PHPstupid 时间: 2014-12-29 11:18 标题: 请教mysql查询优化 select DISTINCT a.employee_id,a.account,a.account_state,c.created_date as account_effect_date,c.phone,c.employee_name,b.mobilebureau,d.company_shorter_name,
e.use_cycle,e.eff_type,e.service_desc,e.create_date,e.result_code,e.item_value,e.personpayflag,e.result_msg
from t_employee_account a left join t_system_employee c on a.employee_id=c.employee_id left join t_company d on a.company_id=d.company_id
left join t_mobilenumber_head b on a.account LIKE CONCAT(b.numberhead,'%') left join tbl_ngec_request e on a.account = e.account