Hi, 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_ Complete log: ===== $ ./sqlite3 mysqlitedb SQLite version 3.6.18 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .schema CREATE TABLE FRIENDS(fname varchar, lname varchar, bday varchar); CREATE TABLE NAMES(first_name varchar(30), last_name varchar(30)); sqlite> select * from names, friends where first_name = fname and _rowid_ < 2; SQL error: no such column: _rowid_ ===== Thanks -sk _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users