Full Outer Join - Police Department

SELECT
    officers.officer_id,
    officers.officer_name,
    officers.rank,
    assignments.precinct_id,
    assignments.precinct_name,
    assignments.years_of_service
FROM officers
FULL OUTER JOIN assignments
    ON officers.officer_id = assignments.precinct_id;