Cognizant Interview Question

Describe the joining concept in SQL