I have two tables, one has security applied to it and the other does not. I need to pull information from both. There could be redundant data between the tables.
Secure : Log in and see only job data for your department
Unsecure : Some of the same columns as Secured, but you can see outside your department.
What I need to do is combine the unique results. However, because "unsecure" does not have all the columns that "secure" does, I have to put in placeholders for the union to work. Because of the placeholders, the union thinks every result is unique.
SELECT effective_dt, action,compensation
1/1/2008 HIRE 52,000
9/9/2008 TERM 56,000
What I want to display is the 1/1 and 9/9 rows that show compensation and the 8/5 row.