Pergunta de entrevista da empresa PCL Construction

What is the difference among JOIN statements?