Content Comparison

SELECT DISTINCT 
applicant.application_id as 'Application ID',
applicant.name as 'Applicant Name',

applicant.username as 'Applicant''s UH Username',

officeapplication.descriptionyear as 'OfficeYear',
campus.description as 'Campus',
hrdw_employee.current_classificationoffice.description as 'Current ClassificationOffice',

hrdw_employee.current_rankCONCAT(rank.classification_code, rank.code) as 'Current Classification and 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,
(SELECT eligibility.application_id, appointment_rank.classification_code, appointment_rank.code FROM eligibility LEFT JOIN appointment_rank ON eligibility.current_rank_id=appointment_rank.id) `rank`
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.uhuuidapplication_id=rank.application_id AND
campus.code='MA' AND
application.year=2020
ORDER BY applicant.application_id;