Isn't proper SQL select * from (select user.id from user ) blah where blah.id=1 ; ?
On Fri, Mar 14, 2008 at 11:40 PM, Jay Sprenkle <[EMAIL PROTECTED]> wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
