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

A Short Review of Sets

Finding Out the “NOT” Case

Finding Multiple Match in the Same Tables

Sample Statements


Problems for You to Solve

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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.