20. Using Unlinked Data and “Driver” Tables

“If you only have a hammer, you tend to see every problem as a nail.”

—Abraham Maslow

Topics Covered in This Chapter

What Is Unlinked Data?

Solving Problems with Unlinked Data

Solving Problems Using “Driver” Tables

Sample Statements

Summary

Problems for You to Solve

Before you start this chapter, make sure you get a good night’s sleep! And while we’re doling out warnings, perhaps you should also make sure your seat belt is securely fastened. We promised that we would introduce you to concepts that make you think “outside the box.” In this chapter, we are going to tackle problems that can be solved using unlinked data—problems where you will use more than one table in your FROM clause, but you won’t ...

Get SQL Queries for Mere Mortals®: A Hands-On Guide to Data Manipulation in SQL, Third Edition 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.