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

Reply via email to