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, IB.BUSINESS_NUMBER, BA.ADDRESS_ID, BAP.PHONE_ID, B.business_name, I.LOC_CODE, I.LOCATION_OF_IMPOUND FROM VEHICLES V, VEHICLE_DESCRIPTIONS VD, IMPOUND I, IMPOUND_BUSINESSES IB, BUSINESSES B, BUSINESS_ADDRESSES BA, BUSINESS_ADDR_PHONES BAP WHERE VD.VEHICLE_ID=V.VEHICLE_ID and I.VEHICLE_ID=V.VEHICLE_ID and I.DATE_OF_INFO=VD.DATE_OF_INFO and IB.IMPOUND_ID=I.IMPOUND_ID and IB.BUSINESS_NUMBER=B.BUSINESS_NUMBER and BA.BUSINESS_NUMBER(+)=B.BUSINESS_NUMBER and BAP.BUSINESS_NUMBER(+)=B.BUSINESS_NUMBER