Joins can range from a simple Join (Outer or Inner) to an assortment of less simple joins

SQL Joins