What are all the fault descriptions and the fault status of all the faults recoreded in the logs?
create table fault_log (fault_description varchar, fault_log_entry_id varchar, PRIMARY KEY (fault_description)); create table fault_log_parts (fault_status varchar, fault_log_entry_id varchar, PRIMARY KEY (fault_status))
select t1.fault_description, t2.fault_status from fault_log as t1 join fault_log_parts as t2 on t1.fault_log_entry_id = t2.fault_log_entry_id