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 , I.LOC_CODE , I.LOCATION_OF_IMPOUND FROM VEHICLES V, VEHICLE_DESCRIPTIONS VD, IMPOUND I WHERE VD.VEHICLE_ID=V.VEHICLE_ID and I.VEHICLE_ID=V.VEHICLE_ID and I.DATE_OF_INFO=VD.DATE_OF_INFO