Indus Valley Partners interview question

What are Join operations in SQL