What is the difference between INNER JOIN and LEFT JOIN? What happens to the row from the left table if there is no corresponding row in the right table?