SELECT d.*,COUNT(*) 个数
FROM departments d INNER JOIN employees e
ON e.department_id = d.`department_id`
GROUP BY department_id
内连接方式:结果集中没有员工数为0的项
####################################################
SELECT d.*,COUNT(*) 个数
FROM departments d LEFT OUTER JOIN employees e
ON e.department_id = d.`department_id`
GROUP BY department_id
左外连接的方式:结果集中有员工数为0的项,但显示为1,???
####################################################
SELECT d.*,(
SELECT COUNT(*)
FROM employees e
WHERE e.department_id = d.`department_id`
) 个数
FROM departments d;
正确的方法:子查询的方式:结果集中有员工数为0的项,显示0