mysql等值连接案例之添加筛选、分组、排序、多表

加挑选

#案例:有奖金的员工名和部门名

SELECT 
    last_name,department_name
FROM
    employees AS e,departments AS d
WHERE
    e.department_id=d.department_id
AND
    e.commission_pct IS NOT NULL;SELECT 
    last_name,depart