On 27 Oct 2019, at 10:09pm, Benjamin Asher <benashe...@gmail.com> wrote:
> SELECT * FROM tab1 LEFT JOIN tab2 ON tab1.x=‘constant’; You're doing a JOIN here. How should the engine know which row of tab2 corresponds to which row of tab1 ? Your query is syntactically correct, but it doesn't appear to do anything useful. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users