> SQLite version 3.7.5 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> CREATE TABLE t1 (a INT); > sqlite> CREATE TABLE t2 (b INT); > sqlite> CREATE TABLE t3 (a INT); > sqlite> SELECT * FROM t1 JOIN t2 ON t1.a = t2.b AND a /* obviously > t1.a */ != 1 JOIN t3 ON t1.a = t3.a; > Error: ambiguous column name: a
I think for SQlite it's not that obviously, that t1.a = a. If you join tables which have the same column names, you need to use the table names. (that's what i read in the documentation..) -Artur- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users