From: "Frank Millman" <fr...@chagford.com>
WITH RECURSIVE temp AS ( [initial-select UNION ALL recursive-select] ) SELECT * FROM temp UNION * FROM temp
Sorry, I meant SELECT * FROM temp UNION SELECT * FROM temp Frank _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users