Write a SQL query using an INNER JOIN and a LEFT JOIN to retrieve matching records from a test execution table and a defect tracking table.
