Hi All, Following is the sqlite CREATE TABLE definition:
If the "TEMP" or "TEMPORARY" keyword occurs in between "CREATE" and "TABLE" then the table that is created is only visible to the process that opened the database and is automatically deleted when the database is closed. Any indices created on a temporary table are also temporary. Temporary tables and indices are stored in a separate file distinct from the main database file. If a <database-name> is specified, then the table is created in the named database. It is an error to specify both a <database-name> and the TEMP keyword, unless the <database-name> is "temp". If no database name is specified, and the TEMP keyword is not present, the table is created in the main database. 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. Please help! Thank you in advance. Mica