Temporary table doesn't exist?!?
Posted on 2008-11-18
I'm using the following query to create a temporary table:
CREATE TEMPORARY TABLE _temptable
SELECT _itemroot AS 'ITEM ROOT',
CASE WHEN _umex = 'FT' THEN (1 + 0)
WHEN _umex = 'LB' THEN (1 + 1)
WHEN _umex = 'EA' THEN (1 + 2)
ELSE 'No UM' END AS 'YIELD'
WHERE _workcenter = 'EXTPACK' AND _date BETWEEN '2008-03-30' AND '2008-03-30'
ORDER BY _itemroot
This runs OK with no warnings... but when I try to query the newly created table (eg, SELECT * FROM _temptable) I get, "Table db_mydata._temptable doesn't exist". What do you mean, "it doesn't exist"? Where did it go? How can I query it?