SELECT DISTINCT a.active_subscription, a.addr_sc_address_subtype_c_type, a.addr_sc_address_subtype_code, a.address_id, a.beat, a.city, a.city_cd_city_code, a.city_cd_city_code_type, a.cntry_cd_country_type_cod_type, a.cntry_cd_country_type_code, a.cnty_cd_county_code, a.cnty_cd_county_code_type, a.creator_date, a.creator_id, a.dirct_cd_direction_code, a.dirct_cd_direction_code_type, a.direct_suffix, a.direct_suffix_type, a.distance1, a.geo_city, a.indx_sec_level_agency, a.indx_sec_level_code, a.indx_sec_level_id, a.indx_type_code, a.intrsect1_dir, a.intrsect1_dir_suffix, a.intrsect1_dir_suffix_type, a.intrsect1_dir_type, a.intrsect1_name, a.intrsect1_street_number, a.intrsect1_street_type_cod_type, a.intrsect1_street_type_code, a.intrsect2_dir, a.intrsect2_dir_type, a.latitude, a.longitude, a.rec_id, a.sstreet_name, a.state_cd_state_code, a.state_cd_state_code_type, a.street_cd_street_type_cod_type, a.street_cd_street_type_code, a.street_name, a.street_number, a.sub_beat, a.sub_number, a.units1, a.updator_date, a.updator_id, a.verify_date, a.verify_status_code, a.verify_status_code_type, a.verify_user, a.zip4, a.zip5, a.beat || '-' || a.sub_beat, ia.address_id, ia.beat, ia.city, ia.city_type_code, ia.creator_date, ia.creator_id, ia.inc_addr_comment, ia.incident_id, ia.rec_id, ia.sub_beat, ia.updator_date, ia.updator_id, i.agncy_cd_agency_code, i.alcohol_related, i.clear_date, i.computer_related, i.creator_date, i.creator_id, i.dispatch_date, i.drug_related, i.end_date, i.end_time, i.gang_related, i.inc_disp_code, i.inc_disp_code_type, i.inc_report_number, i.incident_id, i.internal_incident, i.onscene_date, i.rec_id, i.report_date, i.report_time, i.start_date, i.start_time, i.summary, i.updator_date, i.updator_id, isupp.agency_only, isupp.approval_date, isupp.approval_user_id, isupp.cid, isupp.creator_date, isupp.creator_id, isupp.ds_icr_date, isupp.ds_icr_submission_status, isupp.ds_icr_submission_status_typ, isupp.forward_to_sa, isupp.inc_incident_id, isupp.isc_status_code, isupp.isc_status_code_type, isupp.notify_child, isupp.notify_cid, isupp.notify_dv, isupp.rec_id, isupp.responsible_user_id, isupp.security_level, isupp.supervisor_note, isupp.supp_agency_code, isupp.supp_report_date, isupp.supp_report_time, isupp.supp_seq, isupp.unk_no_offenders, isupp.updator_date, isupp.updator_id, o.ac_code, o.ac_code_type, o.arrest_charge_code, o.bias_code, o.bias_code_type, o.cac, o.campus_code, o.campus_code_type, o.charge_code, o.creator_date, o.creator_id, o.dvu, o.fec_forced_entry_code, o.fec_forced_entry_code_type, o.inc_incident_id, o.offense_number, o.offense_status_date, o.offns_cd_offense_code, o.offnse_cd_offense_status_code, o.place_code_type, o.place_place_code, o.premises, o.pro_property_id, o.rec_id, o.remarks, o.supp_seq, o.ucr_number, o.updator_date, o.updator_id, oc.active_flag, oc.creator_date, oc.creator_id, oc.internal_use_only, oc.offense_code, oc.offense_desc, oc.rec_id, oc.short_list, oc.updator_date, oc.updator_id FROM addresses a, incidents i, incident_supplements isupp, incident_addresses ia, offenses o, offense_codes oc WHERE ia.incident_id = i.incident_id AND ia.address_id = a.address_id AND isupp.inc_incident_id = i.incident_id AND o.inc_incident_id = i.incident_id AND o.offns_cd_offense_code = oc.offense_code AND o.supp_seq = isupp.supp_seq