On Fri, 2005-07-22 at 19:44 -0300, Ming Qiang Lin wrote: > It says that temp table is visible to the process it created, but how > about in this same process, I join a temp table with non-temp table?. > Since I am having Exception says: "no such table" when I do the join. >
The text is wrong and has now been corrected. See http://www.sqlite.org/cvstrac/chngview?cn=2559 TEMP tables in SQLite work like they do in every other SQL database engine. -- D. Richard Hipp <[EMAIL PROTECTED]>