On 6 Sep 2019, at 7:36am, Rowan Worth <row...@dug.com> wrote: > I was surprised when this behaved differently in other SQL engines. eg. in > SQLite you can write: > > SELECT col1, col2 FROM table1, table2 USING
But please don't, for the reason you gave. Not only is it ambiguous but different SQL engines interpret it differently. SQLite uses PostgreSQL as a model for many things but here they diverge. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users