SQL Database Join Operations

It can be challenging to remember the details of all the SQL Join operations.  A convenient way to do this is to use Venn diagrams shown below. For examples of SQL Joins, go here. 

Commonly used SQL Join operations are:

• inner join: requires each record in the two joined tables to have matching records.
• outer join: does not require each record in the two joined tables to have a matching record.

View fullsize