What is the difference between a LEFT JOIN and an INNER JOIN when dealing with null values in large-scale tables?
