SELECT CI.CITATION_ID, CI.TICKET_NUMBER, CI.CITATION_TYPE_CODE, CTC.DESCRIPTION AS CITATION_TYPE_DESC, CI.FILED_DATE, CI.CITATION_DATE, CI.USER_AGENCY, CI.AGENCY_CODE, CAC.AGENCY_DESC, CI.PLAINTIFF, CI.TWP_RD, CI.STATE_DIST_CODE, SDC.DESCRIPTION AS STATE_DIST_DESC, CI.CITY_CODE, CC.DESCRIPTION AS CITY_DESC, CI.COUNTY_CODE, COC.DESCRIPTION AS COUNTY_DESC, CI.BOND_TYPE, BTC.DESCRIPTION AS BOND_TYPE_DESC, CI.MUST_APPEAR, CI.BOND_AMOUNT, CI.POSTED_SPEED, CI.ACTUAL_SPEED, CI.RACE_KNOWN, CI.STOP_COMMENT, CI.PERCEIVED_RACE_CODE, PRC.DESCRIPTION AS PERCEIVED_RACE_DESC, CI.DURATION_CODE, DC.DESCRIPTION AS DURATION_DESC, MN.LNAME as LAST_NAME, MN.FNAME as FIRST_NAME, MN.DOB, MP.RACE_CODE, MP.SEX_CODE, CP.MISC_ID_NUMBER as DL_NUMBER, MID.STATE_CD_STATE_CODE as DL_STATE, CP.PERSON_ID, MP.MASTER_PERSON_ID FROM CITATIONS CI INNER JOIN CITATION_TYPE_CODES CTC ON CI.CITATION_TYPE_CODE= CTC.CITATION_TYPE_CODE INNER JOIN AGENCY_CODES CAC ON CI.AGENCY_CODE = CAC.AGENCY_CODE INNER JOIN EJS_CODES COC ON CI.COUNTY_CODE = COC.CODE AND CI.COUNTY_CODE_TYPE = COC.CODE_TYPE INNER JOIN CITATION_PEOPLE CP ON CI.CITATION_ID = CP.CITATION_ID INNER JOIN MASTER_NAMES MN ON CP.PERSON_ID = MN.PER_PERSON_ID AND CP.MN_ID = MN.MN_ID INNER JOIN PEOPLE P ON CP.PERSON_ID = P.PERSON_ID INNER JOIN MASTER_PEOPLE MP ON P.MASTER_PERSON_ID = MP.MASTER_PERSON_ID LEFT OUTER JOIN MISC_IDS MID ON CP.MISC_ID_CNTR = MID.MISC_ID_CNTR AND CP.MISC_ID_CODE = MID.MISC_CD_MISC_ID_CODE AND CP.MISC_ID_NUMBER = MID.ID_NUMBER AND CP.PERSON_ID = MID.PER_PERSON_ID LEFT OUTER JOIN EJS_CODES CC ON CI.CITY_CODE = CC.CODE AND CI.CITY_CODE_TYPE = CC.CODE_TYPE LEFT OUTER JOIN STATE_DISTRICT_CODES SDC ON CI.STATE_DIST_CODE = SDC.STATE_DIST_CODE LEFT OUTER JOIN BOND_TYPE_CODES BTC ON CI.BOND_TYPE = BTC.BOND_TYPE LEFT OUTER JOIN EJS_CODES PRC ON CI.PERCEIVED_RACE_CODE = PRC.CODE AND CI.PERCEIVED_RACE_CODE_TYPE = PRC.CODE_TYPE LEFT OUTER JOIN EJS_CODES DC ON CI.DURATION_CODE = PRC.CODE AND CI.DURATION_CODE_TYPE = PRC.CODE_TYPE