Michael Black wrote: > > However, it appears that SQLite does not allow correlated subqueries > > in the LIMIT/OFFSET clauses of a scalar subquery: > > > > sqlite> create table t(x); > > sqlite> select (select 42 limit 1 offset (select t.x)) from t; > > Error: no such column: t.x > > Instead of "select t.x" don't you really want "select x from t" ??
No, I want it to be a *correlated* subquery. > I assume you just want the offset to come from a single-row table? It should come (or be derived) from the current row in the outer query. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users