An example to reproduce a problem I noticed: ------------------------------------------------ create table tab(val); insert into tab values(1);
with t(rowid,val) as ( select rowid,val from tab union select rowid,tab.val from tab join t on t.rowid = tab.rowid --from tab join t using(rowid) ) select * from t; ------------------------------------------------ If the 1st FROM is replaced by the 2nd commented out FROM ... USING SQLite3 throws this error: Error: near line 4: cannot join using column rowid - column not present in both tables Aren’t these two FROM clauses practically equivalent? (SQLite version 3.21.0 2017-10-24 18:55:49) _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users