Pergunta de entrevista da empresa CVS Health

Describe the difference in join types in a SQL environment.