In this chapter, we've added the powerful capabilities of joins to our SQL repertoire. We've examined join techniques from two separate syntax families. We learned to write Cartesian joins, equi joins, non-equi joins, and self-joins in the ANSI syntax for both two-table and multi-table joins. With the Oracle syntax, we've looked at various join techniques using the
ON clauses. We've also spent some time expanding our understanding of how table relationships work and graphically examined them for our
Companylink database, in the form of an Entity Relationship Diagram, or ERD.
SELECTstatements to access data from more than one table using equi joins and non-equi joins ...