Pregunta de entrevista de Infosys

Difference between Join, Lookup and Merge.