SmartinfoLogiks interview question

Explain JOINS with their types in sql.