I have to issue a special query.

The query is so complex that I cannot guess how to do it in one step.

So I have decided to create a temporary table, fill it in several steps,
then open and go thru it.

As several users could be working on the same query, I build the name of
the temporary table by adding a suffix and a number given by a generator.
In this way I can be sure that the table name will be unique for every user.

Are there better ways of using temporary tables in FB ?

TIA

Duilio Foschi