On Tue, 3 Sep 2019 at 22:17, Keith Medcalf <kmedc...@dessus.com> wrote:
> And the "," in the list of tables may be replaced by the word JOIN. It is > merely an alternate spelling. > I was surprised when this behaved differently in other SQL engines. eg. in SQLite you can write: SELECT col1, col2 FROM table1, table2 USING (commonId) But in eg. postgres it must be written using "table1 JOIN table2" rather than the comma, because postgres treats "table1, table2" as "table1 JOIN tabel2 ON TRUE" resulting in a conflict with the USING clause. -Rowan _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users