Joins are best conceptualized by using Venn Diagrams
By far the most common and the one you will use the most is the Inner Join
However, the object in SQL is to extract information out of raw data, so you cannot ignore the other types, since they will help you get to the data you need