Content Comparison

SELECT DISTINCT applicant.name as 'Applicant Name', 
applicant.username as 'Applicant''s UH Username', 
office.description as 'Office',
campus.description as 'Campus',

hrdw_employee.current_classification as 'Current Classification', 
hrdw_employee.current_rank as 'Current Rank', 
excluded.name as 'Excluded Faculty''s Name',
excluded.username as 'Excluded Faculty''s UH Username'
FROM application, office, campus, hrdw_employee,
(SELECT application_role.application_id, person.uhuuid, person.name, person.username FROM person INNER JOIN application_role ON person.id=application_role.person_id WHERE application_role.role_id=1) applicant,
(SELECT application_role.application_id, person.name, person.username FROM person INNER JOIN application_role ON person.id=application_role.person_id WHERE application_role.role_id=12) excluded
WHERE
applicant.application_id=excluded.application_id AND
application.id=applicant.application_id AND
application.office_id=office.id AND
campus.id=office.campus_id AND
applicant.uhuuid=hrdw_employee.uhuuid AND
campus.code='HAMA'
ORDER BY applicant.application_id;