There's no reason for following error:
SQLite version 3.6.21 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .headers ON 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> select * from t1 left join t2 using(a) left join t3 using(a); a 1 sqlite> select a from t1 left join t2 using(a) left join t3 using(a); Error: ambiguous column name: a _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
