SELECT V.VEHICLE_ID , V.VMA_VEHICLE_MAKE_CODE , V.VMO_VEHICLE_MODEL_CODE , V.VST_VEHICLE_STYLE_CODE , V.YEAR , V.VIN , VD.BOTTOM_COLOR , VD.TOP_COLOR , VD.LIC_TYPE_CODE , VD.LIC_STATE_CODE , VD.LIC_YEAR , VD.LIC_NUMBER , VD.MISC_ID , VD.COND_CODE , VD.DAMAGE , VD.DATE_OF_INFO , I.IMPOUND_ID , I.DATE_OF_IMPOUND , I.IMPOUNDING_AGENCY , I.REPORTING_AGENCY , I.INCIDENT_NUMBER , I.DATE_OF_RELEASE , I.IMP_DISP_CODE , I.COMMENTS , IO.OFF_ROLE_CODE , O.OFFICER_ID , O.LNAME , O.FNAME , O.AGNCY_CD_AGENCY_CODE AGENCY_CODE , O.TITLE , I.LOC_CODE , I.LOCATION_OF_IMPOUND FROM VEHICLES V, VEHICLE_DESCRIPTIONS VD, IMPOUND I, IMPOUND_OFFICERS IO, OFFICERS O WHERE VD.VEHICLE_ID=V.VEHICLE_ID and I.VEHICLE_ID=V.VEHICLE_ID and I.DATE_OF_INFO=VD.DATE_OF_INFO and IO.IMPOUND_ID=I.IMPOUND_ID and IO.OFFICER_ID=O.OFFICER_ID