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
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
