Cognizant interview question

Difference between join and lookup