How To Join Splitsvilla : This type of join is performed when we want to look up for something from other datasets, the best example would be fetching a phone no.