Can we extract data from 2 same tables using one Select query, in SAP ABAP?

I have 2 tables. They have the exact same fields (say employee and employee_temp).

I need to extract all records in both tables into an internal table (say it_all_employees), where emp_id >10.

Is this possible using one Select query?