How does one run a query to populate a memory table,
emptying it before the query, and then running a query
joining the memory table to a disk table?

Thanks.

"Sanford Aranoff" <aranoff@analysis-knowledge.com> wrote in message
news:474611AF.1886A7B5@analysis-knowledge.com...
> How does one run a query to populate a memory table,
> emptying it before the query, and then running a query
> joining the memory table to a disk table?
>

DROP TABLE IF EXISTS MEMORY\TEMP;
SELECT TFIELD1, TFIELD2 INTO MEMORY\TEMP
FROM TABLE1;
SELECT TFIELD2, DFIELD3 FROM DTABLE
JOIN MEMORY\TEMP ON TFIELD1 = DFIELD1

> Thanks.