CREATE TABLE A(id UNSIGNED INT, tag NVARCHAR(256), value NVARCHAR(256));
CREATE TABLE B(tag NVARCHAR(256), hash NVARCHAR(256));
INSERT INTO A VALUES(1, "color", "red");
INSERT INTO A VALUES(1, "size", "big");
INSERT INTO A VALUES(2, "color", "green");
INSERT INTO A VALUES(2, "size", "small");
INSERT INTO B VALUES("color", "color");
INSERT INTO B VALUES("size", "size");
SELECT A.id,B.tag,value FROM A,B WHERE A.id IN (SELECT DISTINCT id FROM A
WHERE id IN (1, 2) limit 2) AND B.hash=A.tag ORDER BY A.id ASC;
SQLite version 3.8.2 2013-12-06 14:53:30
1|color|red
1|size|big
2|color|green
2|size|small
SQLite version 3.8.7.1 2014-10-29 13:59:56
1|color|red
1|size|big
the correct output is in the version 3.8.2
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
