On Thu, Jun 5, 2008 at 5:36 PM, Tim Tassonis <timtas@xxxxxxxx> wrote: > Is there a way to create temporary tables in another way, so they are > visible between sessions, or do I need to create real tables for my purpose? > And is the perfomance penalty big for real tables, as they have been written > to disk/read from disk? You could create a real table on disk, inserting just the primary keys of the table; then, you could join on the main table, to get the real results. Regards Marco -- Marco Bizzarri http://iliveinpisa.blogspot.com/