Wipro interview question

explain joins in database management system