SmartinfoLogiks Interview Question

Explain JOINS with their types in sql.