我尝试在内部连接一张桌子上的一张桌子。它并肩加入。内联接有替代方法吗？

Question

我在1列上对两个表进行了内部联接。根据方法，它将并排连接。例如

有两张桌子员工(id、日期、部门(employee_1(id、日期、部门(

让我们取下面的员工数据

id   date         department
1    2022-09-09   professor
2    2022-10-08   professor
3    2022-10-11   professor
3    2022-09-02   professor

employee_1表位于下方

id   date         department
1    2021-09-09   professor
2    2021-10-08   professor
3    2021-10-11   professor
3    2021-09-02   professor
4    2021-09-10   professor

如果我用下面的查询内部连接以上两个表

select employee.*, employee_1.* from employee 
inner join employee_1
on employee.id = employee_.id

它将返回到表下方

id   date         department   date 
1    2022-09-09   professor   2022-09-09
2    2022-10-08   professor   2022-10-08
3    2022-10-11   professor   2022-10-11 
3    2022-09-02   professor   2021-09-02

如何获得类似的输出

id       date         department
1    2022-09-09   professor  
2    2022-10-08   professor   
3    2022-10-11   professor   
3    2022-09-02   professor 
1    2021-09-09   professor
2    2021-10-08   professor
3    2021-10-11   professor
3    2021-09-02   professor

如何将上表作为输出？

Answer 1

select id, date, department
from employee
union all
select id, date, department
from employee_1