[z3t4]

Explain the difference between INNER join and LEFT join, when you can do that you know intermediate to advanced SQL.