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 |