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
  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 

Aren’t these two FROM clauses practically equivalent?

(SQLite version 3.21.0 2017-10-24 18:55:49)
sqlite-users mailing list

Reply via email to