我试着把一张桌子连接在另一张桌子上。是并排连接的。有什么可供选择的内部连接吗？

Question

我在一栏内连了两张桌子.按照这个方法，它将并排连接。例如

有两个表employee(id，date，department) employee_1(id，date，department)

让我们看看下面的员工数据

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