I've read the documentation[1] a few times and I don't understand why I get:
Error: no such column: z
with a query like the one below:
CREATE TABLE t1(x INTEGER, y INTEGER);
INSERT INTO t1(x, y) VALUES(2, 1), (3, 2), (6, 4);
CREATE TABLE t2(z INTEGER);
INSERT INTO t2(z) VALUES(4);
SELECT (SELECT y FROM t1 ORDER BY abs(x - z) LIMIT 1) FROM t2;
I expect to get a result like:
SELECT (SELECT y FROM t1 ORDER BY abs(x - 4) LIMIT 1) FROM t2;
2
The actual query I'm trying to write is more complicated and involves date
functions; I hope this explains enough. I'm using 3.15.2:
sqlite> .version
SQLite 3.15.2 2016-11-28 19:13:37 bbd85d235f7037c6a033a9690534391ffeacecc8
I appreciate any help you can offer. Thanks in advance!
Keith Maxwell
[1] https://www.sqlite.org/lang_select.html#order-by
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
