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

Reply via email to