Join (SQL)
Inner joins are fine if both tables have a matching record. However, if one table does not have a record for what the join is being built on, the query will fail.  But if a database programmer needs to grab information in an event that there is not a matching record for a row on one of the tables, they need to use an outer join.