SELECT EMPLOYEES.EMP_TYPE_CODE, EMPLOYEES.AGENCY_CODE, EMPLOYEES.EMPLOYEE_ID, EMPLOYEES.ENC_LNAME, EMPLOYEES.ENC_FNAME, EMPLOYEES.ENC_MNAME, EMPLOYEES.EJS_EMP_ID, EMP_SERVICE_HISTORIES.START_DATE, EMPLOYEES.ENC_DOB, EMP_SERVICE_HISTORIES.END_DATE, EMP_SERVICE_HISTORIES.RANK_TITLE_CODE, EMP_SERVICE_HISTORIES.SRV_ASSIGN_CODE, EMP_SERVICE_HISTORIES.EMP_CATCD_CAT_CODE, EMP_SERVICE_HISTORIES.ASSIGN_CODE ,EMPLOYEES.ENC_SSN ,EMPLOYEES.NUM_ASSIGNED ,EMPLOYEES.NUM_CLOSED ,EMPLOYEES.NUM_PENDING ,EMPLOYEES.OFFICER_ID ,EMPLOYEES.ENC_PLACE_OF_BIRTH ,EMPLOYEES.EMERGENCY_CONTACT ,EMPLOYEES.EMERGENCY_PHONE ,EMPLOYEES.DL_NUMBER ,EMPLOYEES.LOGIN_ID ,EMPLOYEES.LONGEVITY_DATE ,EMPLOYEES.ATT_ID ,EMPLOYEES.BLOOD_CODE ,EMPLOYEES.LAST_ASSIGNED_DATE ,EMPLOYEES.DL_STATE_CODE ,EMPLOYEES.RACE_CODE ,EMPLOYEES.SEX_CODE ,EMPLOYEES.TITLE_CODE ,EMPLOYEES.ETHNICITY_CODE ,EMPLOYEES.ACTIVE FROM EMP_SERVICE_HISTORIES EMP_SERVICE_HISTORIES,EMPLOYEES EMPLOYEES WHERE(EMP_SERVICE_HISTORIES.EJS_EMP_ID(+) = EMPLOYEES.EJS_EMP_ID)