Task: Text to Code
Input (English): Step 1: For each row in Part_Faults table, find the corresponding rows in Fault_Log_Parts table.
Step 2: find fault_description, fault_status of the results of step 1
Output (English): SELECT T1.fault_description , T2.fault_status FROM Part_Faults AS T1 JOIN Fault_Log_Parts AS T2 ON T1.part_fault_id = T2.part_fault_id