Entire Site
Free Trial
Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- DownloadDownload
- PrintPrint
Chapter 12. Using Multiple Tables > Finding Rows with No Match in Another Table
12.6. Finding Rows with No Match in Another Table
12.6.1. Problem
You want to find rows in one table that have no match in another. Or you want to produce a list on the basis of a join between tables, but you want the list to include an entry even when there are no matches in the second table.
12.6.2. Solution
Use a LEFT JOIN. As of MySQL 3.23.25, you can also use a RIGHT JOIN.
