Skip to Content
Former Member
Feb 22, 2013 at 04:11 PM

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?