Accenture interview question

what are joins? write the sql query for under join