It evaluates to the content of the table.
sqlite> create table t(a); sqlite> insert into t values(1); sqlite> insert into t values(2); sqlite> create table t2(a); sqlite> insert into t2 values(1); sqlite> insert into t2 values(2); sqlite> insert into t2 values(3); sqlite> insert into t2 values(4); sqlite> select * from t2 where a in t; 1 2 The table has to have only column though, otherwise you need your own subselect. Syntactically equivalent to: select * from t2 where a in (select * from t); Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems ________________________________ From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Pete [p...@mollysrevenge.com] Sent: Monday, April 30, 2012 11:50 AM To: General Discussion of SQLite Database Subject: EXT :[sqlite] Fwd: Expression syntax Anyone? ---------- Forwarded message ---------- From: Pete <p...@mollysrevenge.com> Date: Thu, Apr 26, 2012 at 10:55 AM Subject: Expression syntax To: sqlite-users@sqlite.org The syntax diagram for an expression using the IN/NOT IN operators shows an option to specify database.tablename as the right operand. What does database.tablename evaluate to? -- Pete -- Pete Molly's Revenge <http://www.mollysrevenge.com<http://www.mollysrevenge.com/>> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
