On Dec 31, 2009, at 6:27 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); > sqlite> insert into t1 values(1); > sqlite> insert into t2 values(2); > sqlite> insert into t3 values(1); > sqlite> select * from t1 join t2 on t1.a < t2.a join t3 using(a); > sqlite> update t3 set a = 2; > sqlite> select * from t1 join t2 on t1.a < t2.a join t3 using(a); > 1|2 > > First join produces 2 columns named a so result of the query should by > similar to: > MySQL: Column 'a' in from clause is ambiguous > PostgreSQL: ERROR: common column name "a" appears more than once in > left table
Already fixed. See http://www.sqlite.org/src/info/f74beaabde > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users D. Richard Hipp d...@hwaci.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users