Chapter 8 · Lesson 2 of 5

02. IN and NOT IN with a subquery

A subquery can give a whole list. IN keeps rows whose value is in it; NOT IN keeps the ones that aren't.