Pergunta de entrevista da empresa Accenture

What is the difference between join and lookup?