Sogeti interview question

Write a SQL join statement