Re: [sqlite] beginner question

--- Dennis Cote <[EMAIL PROTECTED]> wrote: > Qiang wrote: > > hello, > > > > two questions.. > > > > 1. comparing select one or two columns from one > row > > from a bigger table ( 20,000 - 30,000 rows, 20 > columns > > ). > >wi

[sqlite] beginner question

makes it? 2. Comparing select a sequence number first from a small table THEN select all rows from another table that have the same sequence number ( hence two selects ) with join select on this two tables where they have the same sequence number. any difference here? thanks, Qiang

[sqlite] Question about sqlite TEMP table

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