Pergunta de entrevista da empresa Accenture

Explain the difference between INNER JOIN and LEFT JOIN in SQL.