Simply put: you join a table with a table valued function.

This article explains the concept and has some examples:

SQL Server APPLY Basics[/url]