I have two versions of the same table with minor differences. I open one database (test1) and attach the second (test2)
SELECT test2.table1.* FROM test2.table1 LEFT JOIN table1 table11 ON test2.table1.id = table11.id Gives an error condition near "*": syntax error. provide an alias for the table and it works OK SELECT testtab.* FROM test2.table1 testtab LEFT JOIN table1 table11 ON testtab.id = table11.id Cheers _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users