Completion requirements
It is helpful to visualize the result (that is, the semantics) of SQL statements and clauses. Review this depiction of the results of the types of join clauses using set diagrams.
Click on SQL JOINS to open the resource.