Chapter 12. Using Multiple Tables

Section 12.0.  Introduction

Recipe 12.1.  Finding Rows in One Table That Match Rows in Another

Recipe 12.2.  Finding Rows with No Match in Another Table

Recipe 12.3.  Comparing a Table to Itself

Recipe 12.4.  Producing Master-Detail Lists and Summaries

Recipe 12.5.  Enumerating a Many-to-Many Relationship

Recipe 12.6.  Finding Rows Containing Per-Group Minimum or Maximum Values

Recipe 12.7.  Computing Team Standings

Recipe 12.8.  Using a Join to Fill or Identify Holes in a List

Recipe 12.9.  Calculating Successive-Row Differences

Recipe 12.10.  Finding Cumulative Sums and Running Averages

Recipe 12.11.  Using a Join to Control Query Output Order

Recipe 12.12.  Combining Several Result Sets in a Single Query

Recipe 12.13.  Identifying and Removing Mismatched or Unattached Rows

Recipe 12.14.  Performing a Join Between Tables in Different Databases

Recipe 12.15.  Using Different MySQL Servers Simultaneously

Recipe 12.16.  Referring to Join Output Column Names in Programs