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.