Explain the difference between a LEFT JOIN and an INNER JOIN in terms of query execution plans and how null values in the join key are handled.
