SELECT p.person_id, mp.sex_code "SEX_CODE", mp.race_code "RACE_CODE", a.address_id, a.street_name, a.city AS adrs_city, a.state_cd_state_code AS adrs_state, a.dirct_cd_direction_code, a.street_number, a.street_cd_street_type_code, a.addr_sc_address_subtype_code, a.sub_number, a.zip4, a.zip5, vd.bottom_color "VEH_COLOR_CODE", vd.top_color "VEH_TOP_COLOR_CODE", v.vma_vehicle_make_code "VEH_MAKE_CODE", v.vmo_vehicle_model_code "VEH_MODEL_CODE", v.vehicle_id, v.YEAR, v.vin, v.vst_vehicle_style_code, v.vtc_type_code, vd.lic_number, vd.lic_state_code, vd.lic_year, m.id_number, m.state_cd_state_code, m.cntry_cd_country_type_code, m.misc_cd_misc_id_code, m.date_of_issue, s.smt_id, s.bdy_prt_body_part_code, s.smt_cd_smt_code, s.description, s.ima_image_id, ph.phone_id, ph.pho_typ_cd_phone_type_code, ph.area, ph.prefix, ph.suffix, ph.ext, ph.date_of_info AS phone_date, -- , PH.ADDR_ADDRESS_ID pd.bld_cd_build_code, pd.eye_cd_eye_code, pd.hair_lngth_hair_length_code, pd.skn_cd_skin_code, pd.face_hr_facial_hair, pd.hair_cd_hair_code, pd.height, pd.weight, pd.glasses, pd.date_of_info "phys_desc_date", pd.phys_desc_id, pd.hair_style_code, pi.mc1_mugshot_code, pi.image_date FROM people p, master_people mp, people_vehicles pv, vehicles v, vehicle_descriptions vd, misc_ids m, smts s, physical_descriptions pd, person_addresses pa, addresses a, phones ph, person_images pi WHERE mp.master_person_id(+) = p.master_person_id AND pv.person_id(+) = p.person_id AND v.vehicle_id(+) = pv.vehicle_id AND vd.vehicle_id(+) = v.vehicle_id AND m.per_person_id(+) = p.person_id AND s.per_person_id(+) = p.person_id AND pd.per_person_id(+) = p.person_id AND pa.person_id(+) = p.person_id AND a.address_id(+) = pa.address_id AND ph.per_person_id(+) = p.person_id AND pi.per_person_id(+) = p.person_id