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

Reply via email to