Originariamente inviato da Fabio Heller
Sicuro di aver bisogno di una temporary table? Non è consentito fare un insert... select sulla stessa tabella?
The target table of the INSERT statement cannot appear in the FROM clause of the SELECT part of the query because it's forbidden in ANSI SQL to SELECT from the same table into which you are inserting. (The problem is that the SELECT possibly would find records that were inserted earlier during the same run. When using subselect clauses, the situation could easily be very confusing!)
pare di no... pero' si puo' fare SELECT e poi INSERT