Where to use Sub-Queries

Where a sub-query can go, as a lookup value or list in WHERE, an EXISTS check, a column value, or a table to join.

Updated

Cheat sheet: Where to use Sub-Queries
Category
SQL
Level
Journeyman
Tags
mysql, sql