Ramco Systems interview question

Database related joins