I am reading FUNDAMENTALS OF DATABASE SYSTEMS where it says "In general, a
query written with nested SELECT...FROM...WHERE... blocks and using = or IN
comparison operators can always be expressed as a single block query."
I believe this is true.
Now I wonder whether similar structure with 'NOT IN' comparison operator
can be expressed as a single block query.
Can any body give me an example?