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
