查询员工ID、最高学历和考试分数。使用training和education两个相关的列(staff_id)做查询操作。
education表
training表
情况是需要包含所有员工,但是员工id在任意一个表中均不完整
select training.staff_id,higest_degree,score from training left outer join education on(training.staff_id=education.staff_id)
union
select education.staff_id,higest_degree,score from education left outer join training on(training.staff_id=education.staff_id)