O'Reilly logo
  • Nicky iBanker thinks this is interesting:

build complex filters that do not rely on the tables in your FROM clause

From

Cover of SQL Queries for Mere Mortals®: A Hands-On Guide to Data Manipulation in SQL, Third Edition

Note

when to use subqueries