On 26/09/2009, at 7:35 AM, sub sk79 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_
select * by default does not include the rowid column. You need to request it specifically, like this: select rowid, * If you are joining tables in your select, you need to specify which rowid you want in the output, such as: select names.rowid as rowid, * from names, friends... Beware that this can return multiple rows with the same rowid, if a name has more than one friend. Tom BareFeet -- Comparison of SQLite GUI applications: http://www.tandb.com.au/sqlite/compare/?ml _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
