Question d’entretien chez Infosys

Difference between Join, Lookup and Merge.