Deutsche Bank interview question

Where and how do you use join in sql?