I am sorry, I did not ask the question correctly. I omitted "... link two tables, using foreign key...".
I now see last sentence on http://sqlite.org/lang_createtable.html which states that it is not possible. Roman ________________________________________ From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of Gwendal Roué [gwendal.r...@gmail.com] Sent: Monday, July 24, 2017 3:17 PM To: SQLite mailing list Subject: Re: [sqlite] rowid as foreign key > Le 24 juil. 2017 à 20:58, Roman Fleysher <roman.fleys...@einstein.yu.edu> a > écrit : > > Dear SQLiters, > > Is it possible to link two tables using rowid, the implicit column? I tried > and it did not work, so I presume the answer to my question is "no". Hello Roman, The answer is yes. For example : $ sqlite3 /tmp/db.sqlite sqlite> CREATE TABLE foo (c); sqlite> CREATE TABLE bar (c); sqlite> INSERT INTO foo (c) VALUES ('foo'); sqlite> INSERT INTO bar (c) VALUES ('bar'); sqlite> SELECT foo.rowid, foo.c, bar.rowid, bar.c FROM foo, bar WHERE foo.rowid = bar.rowid; 1|foo|1|bar Gwendal Roué _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users