This query requires me to denormalize information in three different tables and then join the results. Fortunately, I only need to do it one time. What is the best choice for this situation?
Global Temporary Table
Derived Table
Volatile Table
All of the above