Guidepoint Interview Question

What are types of joins in SQL