Due to some legacy apps, I end up with two tables with similar information, but with zero intersection (i.e., both tables are exclusive of each other).
For illustration:
table_one has the fields emp_id and fullname
table_two has the fields employee_id, first_name, and last_name
Now, I need a query that will search for employee ID in both tables and return his/her full name.