On Dec 9, 2009, at 3:42 AM, Wiktor Adamski wrote: > SQLite version 3.6.21 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> create table t1(a int); > sqlite> create table t2(a int); > sqlite> create table t3(a int, b int); > sqlite> insert into t1 values(1); > sqlite> insert into t3 values(1, 1); > sqlite> select * from t1 left join t2 using(a) left join t3 using(a); > 1| > sqlite> select * from (t1 left join t2 using(a)) left join t3 > using(a); > 1| > > I think that correct result should be > 1|1 > MySQL and PostgreSQL agree with me.
Cannot reproduce this problem here: sqlite> d...@computer2:~/work/sqliteG/bld$ ./sqlite3 SQLite version 3.6.21 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> CREATE TABLE t1(a int); sqlite> CREATE TABLE t2(a int); sqlite> CREATE TABLE t3(a int, b int); sqlite> INSERT INTO t1 VALUES(1); sqlite> INSERT INTO t2 VALUES(1); sqlite> INSERT INTO t3 VALUES(1, 1); sqlite> SELECT * FROM t1 LEFT JOIN t2 USING(a) LEFT JOIN t3 USING(a); 1|1 sqlite> SELECT * FROM (t1 LEFT JOIN t2 USING(a)) LEFT JOIN t3 USING(a); 1|1 Dan. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
