MySQL Cookbook

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