The SQL concepts of temporary tables allows for creation of powerful SQL.
Understanding the different types of temporary tables will allow the end user the option to create useful SQL that may be relatively simpler to understand and allow great flexibility.