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 _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
