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. ---------------------------------------------------------------------- Kup wlasne mieszkanie za 72 tys. zl. Sprawdz najlepsze oferty >>> http://link.interia.pl/f24ce _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users