SCII interview question

explain joins in DBMS