On 30-04-2012 18:50, Pete wrote: > 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? >
SQLite version 3.7.2 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> create table t(i int); sqlite> insert into t values(1); sqlite> insert into t values(2); sqlite> insert into t values(3); sqlite> create table r(i int); sqlite> insert into r values(1); sqlite> insert into r values(3); sqlite> select * from r where i not in t; sqlite> select * from r where i in t; 1 3 sqlite> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users