SQL Query

 

SELECT failure_event.f_id, m_id, inventory.i_id, fm_code,
fd_no, failure_event.rem_code, fc_code, om_code,
failure_event.ec_code, f_detected_date, maint_event.su_code,
mac_code, mc_code, maint_event.mc_code,
maint_event.ec_code, m_maint_date, m_mec_manhour,
m_el_manhour, m_inst_manhour, m_patf_pers,
m_active_maint, m_downtime, inventory.owner_id,
inventory.inst_id, op_code, inventory.ee_code,
dc_code, inventory.ec_code, i_checked_by,
i_checked_date, i_tag_no, i_surv_start_date,
i_surv_end_date, i_oper_time, i_oper_time_code,
i_no_of_starts, i_installed_date, i_scrapped_at_end,
m_other_manhour, m_res_drill_rig, m_res_diving_vessel,
m_res_service_vessel, m_res_divers,
m_res_rov_rot

FROM failure_event, maint_event, inventory

WHERE failure_event.f_id = maint_event.f_id
and inventory.i_id = maint_event.i_id and inventory.i_id = 
failure_event.i_id;