LMKR interview question

Explain joins in MySQL database