BNP Paribas Interview Question

What Joins in SQL? Explain with example OOPS