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
in the original post, that's exactly the same as a literal list (or a join)
The question was about that <<WHERE col IN tab>> syntax SQLite allows. --DD
sqlite-users mailing list