According to http://www.sqlite.org/lang_select.html and http://www.sqlite.org/lang_expr.html one can use in select statement as a result column one of the following: - * - table_name.* (I assume that instead of table_name one can use table alias too) - any expression
Expression can consist of the single column in the form [[database_name.]table_name.]column_name So nobody says that database_name.table_name.* should work and behavior is as intended and documented. Though from the point of view of outside user it seems logical for this to work of course. Pavel On Fri, Sep 25, 2009 at 2:01 PM, Schrum, Allan <allan.sch...@rightnow.com> wrote: > $ bin/sqlite3 > SQLite version 3.6.17 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> create table t(a integer); > sqlite> select main.t.* from t; > SQL error: near "*": syntax error > sqlite> select main.t.* from main.t; > SQL error: near "*": syntax error > sqlite> select t.* from t; > sqlite> select t.* from main.t; > sqlite> select main.t.* from main.t; > SQL error: near "*": syntax error > sqlite> select main.t.a from main.t; > sqlite> select main.t.a from t; > sqlite> .quit > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users