6 Performing Complex Joins with Multiple Tables
In Chapter 5, you saw how to join two tables and display the data in one result set. In this chapter, you’ll create complex joins with more than two tables, learn about associative tables, and see how to combine or limit the results of a query. You’ll then explore different ways to temporarily save a query’s results in a table-like format, including temporary tables, derived tables, and Common Table Expressions (CTEs). Finally, you’ll learn how to work with subqueries, which let you nest one query inside another for more refined results.
Writing One Query with Two Join Types
Joining three or ...
Get MySQL Crash Course now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
