Cognizant interview question

Describe the joining concept in SQL