On Mon, Apr 30, 2012 at 7:31 PM, Simon Slavin <slav...@bigfraud.org> wrote:
> >> column. You cannot provide a table and column, it must
> >> be a single-column table.
> >>
>
> I see no conflict with what Jay wrote. The diagram says that db.table is
> allowed. Jay has said that this works, but only when the table concerned
> is a single-column table. You cannot specify something like
> db.table.column using this syntax.
>
"You cannot provide a table and column"
means (to me, anyway) that foo.bar is illegal where as foo is legal.
Perhaps i missed some of the context which qualifies the "cannot" with an
"except when..." clause. The text, as pasted in, clearly prohibits foo.bar
AND requires that foo have only one column (not either/or). Note the words
"must" and "cannot" in the 2nd and 3rd sentences:
-------------------------
Using SQLite, Appendix D (Expression Reference), "IN", p355:
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 expression.
----------------------
--
----- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
