On Fri, Sep 16, 2016 at 6:00 PM, J Decker <d3c...@gmail.com> wrote: > but probably what you mean is... >
I didn't mean anything. I asked a question about an unusual syntax. > SELECT * FROM t1 join T2 on x=y; > SELECT * FROM t1 join (select y from t2) on x=y > A join works too, but that's beside the point. Logically I don't see any difference with <<where x in ...>> and a join when not accessing columns from the "joined" on column in the select list. A good query planner will use as good a plan in both situation. but I'm not a SQL expert. select * from table where colName in (1,2,3,4) /// woud return rows where > some column has a value of 1,2,3 or 4 > And? if those values are rows in a single-column table, as I already demonstrated in the original post, that's exactly the same as a literal list (or a join) logically. The question was about that <<WHERE col IN tab>> syntax SQLite allows. --DD _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users