18. “NOT” and “AND” Problems
“For every complex problem, there’s ananswer that is clear, simple, and wrong.”
—H. L. Mencken
Topics Covered in This Chapter
Finding Multiple Match in the Same Tables
At this point (especially if you’ve been a good student and have worked through all the sample statements and problems), you should be very comfortable with the basics of the SQL database language. Now, in the words of a famous Louisiana chef, it’s time to “kick it up a notch.” In this chapter, we’re going to walk you through more complex problems to find out when something “is not” and when something “is” under multiple conditions. In Chapter 19, “ ...
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.
