This query works as expected: SELECT aa.*,bb.* FROM ((SELECT 1 AS a) AS aa JOIN (SELECT 3 AS b) AS bb) JOIN ((SELECT 2 AS c) AS cc JOIN (SELECT 3 AS d) AS dd);
But If we choose a table from the second nest, SQLite throws "no such table" error: SELECT cc.*,dd.* FROM ((SELECT 1 AS a) AS aa JOIN (SELECT 3 AS b) AS bb) JOIN ((SELECT 2 AS c) AS cc JOIN (SELECT 3 AS d) AS dd); Bug is present in "SQLite version 3.7.13 2012-06-11 02:05:22" SQLFiddle: http://sqlfiddle.com/#!5/d41d8/109 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
