phil has a blog - MySQL Correlated Subqueries

MySQL Correlated Subqueries

May 15, 2009

Example: Return the folders name, count the number of files inside and order by the amount.

SELECT folders.name, (SELECT COUNT(files.folder_id) FROM files WHERE files.folder_id = folders.folder_id) AS files_inside 
FROM folders
ORDER BY files_inside DESC