Thread:Project:Support desk/Mediawiki Database abstraction layer wrapper functions: how to CREATE TEMPORARY TABLE/reply (3)

Thanks for that,

It was the way to go, this is what I did:
 * 1) pre-created a permanent template in the database
 * 2) used duplicateTableStructure to create a new table before the main query (made sure that the temporary flag was set to true)
 * 3) ..ran the query that needs to join to the temp table

Et viola! the temporary table (along with the un-needed data) disappears after the query,leaving the empty permanent template ready for the next query.