Integration Services :: Combining Duplicate Data

I have two tables that I UNION to retrieve data for users.  A combination of these should have only one employee in the table.  The problem is there is a unique id created for the position of instructors.  In the other table, it holds all employees with an employee number.  Some data such as username, email address, etc., does not change.  So even though UNION should remove duplicates, I still have duplicates because of usernames is what I'm filtering on, it is the same in each table.  In the combined table I'm only selecting specific employees based on Job class and Job code.  For employee id in the first table it is preceeded with 'B', and the second by 'T' (this is only to identify which table the data is taken from).  Here is what I am getting when I Union both tables.

query
SELECT
distinct 'B-'+ Employee_ID 
as Employee_ID
, Username
,Email 

[code]...