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

Reply via email to