Pergunta de entrevista da empresa Infosys

Difference between Join, Lookup and Merge.