Have you ever used derived tables? If not, you might want to consider them. A derived table is simply a table that contains the results of a query. It's similar to a view, but it's not created and stored in the database. Encapsulated within the SELECT statement, it's dynamic and temporal.