On Wed, Jan 12, 2011 at 07:09:16PM -0500, sub sk79 scratched on the wall: > Hi, > > The 'IN' operator syntax diagram shows a possible table name operand > IN [Database_Name DOT ] Table_Name > But its description seems to be missing from the paragraph about 'IN' > operator down on the page.
From "Using SQLite" ( http://oreilly.com/catalog/9780596521196/ ), page 355: The last way to define the test group is by providing a table name. The table must consist of only a single column. You cannot provide a table and column, it must be a single-column table. This final style is most frequently used with temporary tables. If you need to execute the same test multiple times, it can be more efficient to build a temporary table (for example, with CREATE TEMP TABLE...AS SELECT), and use it over and over, rather than using a subquery as part of the IN operator. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users