Section 12.1. Introduction
Section 12.2. Combining Rows in One Table with Rows in Another
Section 12.3. Performing a Join Between Tables in Different Databases
Section 12.4. Referring to Join Output Column Names in Programs
Section 12.5. Finding Rows in One Table That Match Rows in Another
Section 12.6. Finding Rows with No Match in Another Table
Section 12.7. Finding Rows Containing Per-Group Minimum or Maximum Values
Section 12.8. Computing Team Standings
Section 12.9. Producing Master-Detail Lists and Summaries
Section 12.10. Using a Join to Fill in Holes in a List
Section 12.11. Enumerating a Many-to-Many Relationship
Section 12.12. Comparing a Table to Itself
Section 12.13. Calculating Differences Between Successive Rows
Section 12.14. Finding Cumulative Sums and Running Averages
Section 12.15. Using a Join to Control Query Output Order
Section 12.16. Converting Subselects to Join Operations
Section 12.17. Selecting Records in Parallel from Multiple Tables
Section 12.18. Inserting Records in One Table That Include Values from Another
Section 12.19. Updating One Table Based on Values in Another
Section 12.20. Using a Join to Create a Lookup Table from Descriptive Labels
Section 12.21. Deleting Related Rows in Multiple Tables
Section 12.22. Identifying and Removing Unattached Records
Section 12.23. Using Different MySQL Servers Simultaneously