BNP Paribas interview question

What Joins in SQL? Explain with example OOPS