See below for a summary of the different join types in SQL. For an excellent discussion of SQL Set operators, see this paper by Howard Schreier.