Don't have Telegram yet? Try it now!
http://www.techmixing.com/2009/09/difference-between-subquery-nested.html
Difference between Subquery, Nested Subquery and Correlated Subquery