I'm not sure if this counts as a bug or not. SQLite version 3.5.2 Enter ".help" for instructions sqlite> select * from (select user.id from user ) ; 0 1 2 3 4 sqlite> select * from (select user.id from user ) where id=1 ; SQL error: no such column: id sqlite> select * from (select user.id from user ) where user.id=1 ; SQL error: no such column: user.id sqlite> select * from (select user.id from user ) as blah where blah.id=1 ; SQL error: no such column: blah.id sqlite> select * from (select user.id from user ) as blah where blah.user.id=1 ;
SQL error: no such column: blah.user.id sqlite> Should the result of a subselect have a table name? If not, how do you reference it? -- The PixAddixImage Collector suite: http://groups-beta.google.com/group/pixaddix SqliteImporter and SqliteReplicator: Command line utilities for Sqlite http://www.reddawn.net/~jsprenkl/Sqlite Cthulhu Bucks! http://www.cthulhubucks.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users