使用UNION谓词将讲师和所有2010年(含)以后参加工作的职工信息的集合显示输出。
提示:查询职工信息可以采用select tbl_employees.*来查询;讲师分为多个级别,可以使用like和%实现。
SELECT e.employee_id, e.department_id, e.name, e.gender, e.date_of_birth, e.starting_date, r.rank_title, e.marital_status, e.education, e.base_salary, e.phone
FROM tbl_employees e
JOIN tbl_rank_salary r
ON e.rank_id = r.rank_id
WHERE e.starting_date >= '2010-01-01' AND e.title = '教师'
UNION ALL
SELECT e.employee_id, e.department_id, e.name, e.gender, e.date_of_birth, e.starting_date, r.rank_title, e.marital_status, e.education, r.salary, e.phone
FROM tbl_employees e
JOIN tbl_rank_salary r
ON e.rank_id = r.rank_id
WHERE e.starting_date >= '2010-01-01' AND e.title != '教师'