select * from (select * from names, friends where first_name = fname) where _rowid_ < 2;
Above query works - which _rowid_ is this accessing? Since the query works I get an impression the rowid is attached with the result-set returned by a select? -sk On Fri, Sep 25, 2009 at 6:07 PM, Igor Tandetnik <itandet...@mvps.org> wrote: > sub sk79 <subs...@gmail.com> wrote: >> Select with two tables joined has no _rowid_ column in select columns. >> I think this is a bug - just a quick check with the community before >> filing a bug report. >> >> select * from names, friends where first_name = fname and _rowid_ < 2; >> SQL error: no such column: _rowid_ > > So, which table's _rowid_ is this statement supposed to access? The > statement is wrong and shouldn't run. The only issue here is that the > error message is somewhat misleading - it could probably say something > like "ambiguous column name". > > Igor Tandetnik > > > > _______________________________________________ > 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