Ambit Software interview question

1. What is join and explain its type?