I'm joining two tables, one is a list of links and the other is a list of categories. The links are organized using a category ID. I would like to select all the links, and break them into ...

In addition to using subselects to examine data in related tables, it’s also possible to use an aggregate function in a WHERE clause subselect to make a determination about the primary result set.