Using queries as tables inside other queries

This video describes the process of creating queries that can relate two or more records in the same table to each other, such as "Find all the actors who appeared in a movie with Kevin Bacon"