Windowmaker Software interview question

Types of joins and difference between them in SQL.