There are three categories of joins that you can make use of in SQL:

But before we dive into the categories of joins, we first need to have an understanding of what a join really is.

Joins are used in SQL to bring together all the relevant data from multiple database tables.  Remember that we've broken data down into multiple tables and established relationships between the tables.

... More via show notes: http://howtoprogramwithjava.com/session46