On 18 Dec 2016, at 6:13pm, Keith Maxwell <[email protected]> wrote:
> I'm afraid I don't follow Simon. z is a column in t2. The sub-select > uses z in an expression in its order by clause: abs(x - z). What do > you mean by "your sub-select only refers to table t1"? Then perhaps instead of > SELECT (SELECT y FROM t1 ORDER BY abs(x - z) LIMIT 1) FROM t2; You want to change which one is the sub-select: SELECT y FROM t1 ORDER BY abs(x - (SELECT z FROM t2)) LIMIT 1; Simon. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
