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 8. INNER JOINs > Uses for INNER JOINs
Uses for INNER JOINs
Now that you have a basic understanding of the mechanics for constructing an INNER JOIN, let’s look at some of the types of problems you can solve with it.
Find Related Rows
As you know, the most common use for an INNER JOIN is to link tables so that you can fetch columns from different tables that are related. Following is a sample list of the kinds of requests you can solve from the sample databases using an INNER JOIN.
