SELECT e.employee_id AS "Employee ID"
    , pp.current_first_name AS "First Name"
    , pp.current_last_name AS "Last Name"
    , ps.position_title AS "Job Title"
    , e.salary AS "Salary"
    , e.manager_id AS "Manager ID"
    , cm.address1 || ' ' || gb.city_name || ' ' || cm.postal_code || ' ' || gb.prov_name
        || ' ' || gb.country_abbrev AS "Address"
    , pmc.phone_number AS "Phone Number"
    , pmc.email AS "Email Address"
FROM employees e
   , people pp
   , positions ps
   , contact_mechanisms cm
   , party_contact_mechanisms pmc
   , geographic_boundaries gb
   , party_roles pr
   , parties pt
WHERE gb.geo_id = cm.geo_id
AND cm.contact_mechanism_id = pmc.contact_mechanism_id
AND pmc.party_id = pt.party_id
AND pt.party_id = pr.party_id
AND pr.employee_id = e.employee_id
AND e.position_id = ps.position_id
AND pt.person_id = pp.person_id;