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

to fetch data from another table, even if the table isn’t 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