Pregunta de entrevista de BNP Paribas

What Joins in SQL? Explain with example OOPS