Cognizant Interview Question

Difference between join and lookup