Pergunta de entrevista da empresa Cognizant

Difference between join and lookup