Deutsche Bank Interview Question

Where and how do you use join in sql?