Temporary Tables
You can use the CREATE TEMPORARY TABLE
statement to implement certain queries using multiple steps:
- Create one or more temporary tables.
- Execute queries and store the result sets in the temporary tables.
- Execute the main query using the temporary tables as if they were a normal part of the logical schema.
See CREATE TEMPORARY TABLE in the SQL Reference Manual for details.