(client_rating,0))/count(crm_client_assign.client_id)),0)*100)/5))/392.10000000)*100 as valJOIN `crm_project_assign` ON `crm_clients`.`client_id` = `crm_project_assign`.`client_id`
JOIN `crm_projects`
我的3张表格如下:location_id,lang_id,路径crm_status_id,crm_status_namestore_crm_id,状态( crm_status_id of crm_statuses表中的引用),location_id ( location_id of locations表中的引用)
我希望通过加入store_crm作为行,我想获得crm</em