If you applied LEFT JOIN, what would change?

LEFT JOIN returns all records from the left table and the matching records from the right table. If there are no matches, the right table columns will contain NULL. Unlike INNER JOIN, which returns only matching records, LEFT JOIN extends the result to include all rows from the left table, even if there are no matches.

For example, if you have an employees table and a departments table, and you use LEFT JOIN, you will get all employees, including those not assigned to any department (in this case, the department fields will be NULL). This is useful when you want to keep all data from the main table without losing rows due to missing relationships.