Barclays interview question

Describe JOINS concept in DBMS Sorting Algorithms