Pandu Poluan, 12.12.2011 05:39:
> 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.
> How do I do that? Will a simple UNION suffice?
Yes a UNION should do (actually a UNION ALL as it will not try to remove duplicates which makes the query faster)
select emp_id, fullname
where emp_id = 1
In response to
pgsql-novice by date
|Next:||From: Jean-Yves F. Barbier||Date: 2011-12-12 18:10:53|
|Subject: index or not|
|Previous:||From: Pandu Poluan||Date: 2011-12-12 04:39:19|
|Subject: SELECT from two tables with different field names?|