Ian,

<< But, unless I am missunderstanding, currently, the temporary table has to have already been created to
insert into,  I was hoping to have it automatically be created based on the insert and source table. >>

In that case, you should use this instead:

CREATE TEMPORARY TABLE MyTable
(LIKE MyOtherTable);

INSERT INTO...

or do like Roy suggests and use CREATE TEMPORARY TABLE MyTable AS SELECT...

Tim Young
Elevate Software
www.elevatesoft.com