21,886
社区成员
发帖
与我相关
我的任务
分享
SELECT au.user_id, count(u.workno) AS tjs
FROM ecs_users AS u, ecs_admin_user AS au
WHERE au.workno = u.workno
AND au.action_list LIKE '%user_sales%'
GROUP BY au.user_id
SELECT au.user_id, count(u.workno) AS tjs
FROM ecs_admin_user AS au LEFT JOIN ecs_users AS u
ON au.workno = u.workno GROUP BY au.user_id
SELECT au.user_id, count(u.workno) AS tjs
FROM ecs_admin_user AS au LEFT JOIN ecs_users AS u
ON au.workno = u.workno AND au.action_list LIKE '%user_sales%'
GROUP BY au.user_id